HXT Premium Elg. Policy Tbl List

Description
Categories: BI Publisher
Application: Time and Labor
Source: Premium Elg. Policy Tbl List (XML)
Short Name: HXT956D_XML
DB package: HXT_HXT956D_XMLP_PKG
Run HXT Premium Elg. Policy Tbl List and other Oracle EBS reports with Blitz Report™ on our demo environment
select EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, ELT_BASE_ID, ELT_PREMIUM_ID, PEP_ID, 
	HXT_HXT956D_XMLP_PKG.bhtformula(HXT_PREM_ELIGBLTY_RULES.ELT_BASE_ID, HXT_PREM_ELIGBLTY_RULES.EFFECTIVE_START_DATE, HXT_PREM_ELIGBLTY_RULES.EFFECTIVE_END_DATE) BHT, 
	HXT_HXT956D_XMLP_PKG.premformula(HXT_PREM_ELIGBLTY_RULES.ELT_PREMIUM_ID) PREM
from 
HXT_PREM_ELIGBLTY_RULES 
 where HXT_PREM_ELIGBLTY_RULES.PEP_ID=:ID
Blitz Report™