HXT Prem. Interaction Plcy Tbl Lst

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

Blitz Report™ provides multiple benefits: