HXT Hour Deduction Plcy Tbl List

Description

Categories
BI Publisher
Application
Time and Labor
Source
Hour Deduction Plcy Tbl List (XML)
Short Name
HXT956B_XML
DB package
HXT_HXT956B_XMLP_PKG

SQL 5 lines

select EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, FCL_DEDUCTION_TYPE, HDP_ID, HOURS, TIME_PERIOD
from HXT_HOUR_DEDUCTION_RULES 
WHERE HXT_HOUR_DEDUCTION_RULES.HDP_ID=:ID
order by fcl_deduction_type