HXT Shift Diff. Pol. Table Listing

Description
Categories: BI Publisher
Columns: Carryover Time, Effective End Date, Effective Start Date, Element Type Id, Id1, Name, Sdp Id, Start Time, Stop Time, Earn Type ...
Application: Time and Labor
Source: Shift Diff. Pol. Table Listing (XML)
Short Name: HXT956C_XML
DB package: HXT_HXT956C_XMLP_PKG
select R.CARRYOVER_TIME, R.EFFECTIVE_END_DATE, R.EFFECTIVE_START_DATE, R.ELEMENT_TYPE_ID, ID ID1, R.NAME, R.SDP_ID,R.START_TIME, R.STOP_TIME, 
	HXT_HXT956C_XMLP_PKG.earn_typeformula(R.ELEMENT_TYPE_ID, R.EFFECTIVE_START_DATE, R.EFFECTIVE_END_DATE) EARN_TYPE
from HXT_SHIFT_DIFF_RULES R 
where R.SDP_ID=:ID
ORDER BY R.NAME