HXT Premium Elg. Policy Tbl List Copy link

➜ Back to Library
XMLXML import file

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

SQL 7 lines

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