HXT Earning Policy Table Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: Earning Policy Table Listing (XML)
Short Name: HXT956A_XML
DB package: HXT_HXT956A_XMLP_PKG
Run HXT Earning Policy Table Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  HXT_EARNING_POLICIES.ID, 
HXT_EARNING_POLICIES.NAME POL_NAME, HXT_EARNING_POLICIES.DESCRIPTION, 
HXT_EARNING_POLICIES.FCL_EARN_TYPE, TO_CHAR(HXT_EARNING_POLICIES.EFFECTIVE_START_DATE ,'YYYYMMDD') EFFECTIVE_START_DATE1, 
TO_CHAR(HXT_EARNING_POLICIES.EFFECTIVE_END_DATE ,'YYYYMMDD') EFFECTIVE_END_DATE1, HXT_HOLIDAY_CALENDARS.NAME CAL_NAME, 
HXT_EARNING_POLICIES.MIN_TCARD_INTVL, HXT_EARNING_POLICIES.ROUND_UP,
 HXT_EARNING_POLICIES.EGT_ID, 
HXT_EARNING_POLICIES.PEP_ID,
 HXT_EARNING_POLICIES.PIP_ID, 
	HXT_HXT956A_XMLP_PKG.cf_pep_nameformula(HXT_EARNING_POLICIES.PEP_ID) CF_PEP_NAME, 
	HXT_HXT956A_XMLP_PKG.cf_pip_nameformula(HXT_EARNING_POLICIES.PIP_ID) CF_PIP_NAME, 
	HXT_HXT956A_XMLP_PKG.cf_egt_nameformula(HXT_EARNING_POLICIES.EGT_ID) CF_EGT_NAME
FROM HXT_EARNING_POLICIES, HXT_HOLIDAY_CALENDARS
WHERE (HXT_EARNING_POLICIES.HCL_ID=HXT_HOLIDAY_CALENDARS.ID)
Download
 
Related Blitz Reports
HXT Holiday Calendar Table HXT Total Hours To BEE HXT Time Entry Detail HXT Actual and Rounded Time Punch HXT Person/Assignment Table List HXT Earning Variance Calculation HXT Location Variance Calculation HXT Organization Variance Calc HXT Hour Deduction Plcy Tbl List
Blitz Report™

Blitz Report™ provides multiple benefits: