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
SQL 6 lines
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 |