HXT Earning Policy Table Listing

Description

Application: Time and Labor
Source: Earning Policy Table Listing (XML)
Short Name: HXT956A_XML
DB package: HXT_HXT956A_XMLP_PKG

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

Copy

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)