HXT Shift Diff. Pol. Table Listing

Description
Categories: BI Publisher
Application: Time and Labor
Source: Shift Diff. Pol. Table Listing (XML)
Short Name: HXT956C_XML
DB package: HXT_HXT956C_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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