HXT Premium Elg. Policy Tbl List

➜ Back to Library
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
Download
Related Blitz Reports
HXT Prem. Interaction Plcy Tbl Lst HXT Work Plan Table Listing HXT Hour Deduction Plcy Tbl List HXT Shift Diff. Pol. Table Listing BEN Reconciliation of Premium Contributions to Element Entries PAY KR Health Insurance Premium Adjustment Annual Earnings BEN Premium Calculation Summary BEN Premium Calculation Audit Log HXT Location Variance Calculation
Blitz Report™

Blitz Report™ provides multiple benefits: