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
Source: Prem. Interaction Plcy Tbl Lst (XML)
Short Name: HXT956E_XML
DB package: HXT_HXT956E_XMLP_PKG
Run
HXT Prem. Interaction Plcy Tbl Lst and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |