HXT Premium Elg. Policy Tbl List

Description
Categories: BI Publisher, Human Resources
Application: Time and Labor
Source: Premium Elg. Policy Tbl List (XML)
Short Name: HXT956D_XML
DB package: HXT_HXT956D_XMLP_PKG
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