HXT Prem. Interaction Plcy Tbl Lst

Description
Categories: BI Publisher, Human Resources
Application: Time and Labor
Source: Prem. Interaction Plcy Tbl Lst (XML)
Short Name: HXT956E_XML
DB package: HXT_HXT956E_XMLP_PKG
select APPLY_PRIOR_PREM_YN, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, ELT_EARNED_PREM_ID, ELT_PRIOR_PREM_ID, PIP_ID, 
	HXT_HXT956E_XMLP_PKG.earn_premformula(HXT_PREM_INTERACT_RULES.ELT_EARNED_PREM_ID, HXT_PREM_INTERACT_RULES.EFFECTIVE_START_DATE, HXT_PREM_INTERACT_RULES.EFFECTIVE_END_DATE) EARN_PREM, 
	HXT_HXT956E_XMLP_PKG.ppremformula(HXT_PREM_INTERACT_RULES.ELT_PRIOR_PREM_ID, HXT_PREM_INTERACT_RULES.EFFECTIVE_START_DATE, HXT_PREM_INTERACT_RULES.EFFECTIVE_END_DATE) PPREM, 
	HXT_HXT956E_XMLP_PKG.incexcformula(HXT_PREM_INTERACT_RULES.APPLY_PRIOR_PREM_YN) INCEXC, 
	HXT_HXT956E_XMLP_PKG.edateformula(HXT_PREM_INTERACT_RULES.EFFECTIVE_END_DATE) EDATE
from HXT_PREM_INTERACT_RULES 
 where HXT_PREM_INTERACT_RULES.PIP_ID=:ID
order by effective_start_date,ELT_EARNED_PREM_ID