HXT Prem. Interaction Plcy Tbl Lst

Description
Categories: BI Publisher
Application: Time and Labor
Source: Prem. Interaction Plcy Tbl Lst (XML)
Short Name: HXT956E_XML
DB package: HXT_HXT956E_XMLP_PKG

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

Contact us to schedule a demo or if you need help with the installation

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