DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on BEN_ACTL_PREM_F

Line 676: from ben_actl_prem_f apr

672: apr.upr_lmt_calc_rl,
673: apr.lwr_lmt_val,
674: apr.lwr_lmt_calc_rl,
675: apr.uom
676: from ben_actl_prem_f apr
677: where apr.pl_id = p_pl_id
678: and apr.prem_asnmt_cd = 'ENRT' -- PROC are dealt with in benprplc.pkb
679: and p_date
680: between apr.effective_start_date

Line 699: from ben_actl_prem_f apr

695: apr.upr_lmt_calc_rl,
696: apr.lwr_lmt_val,
697: apr.lwr_lmt_calc_rl,
698: apr.uom
699: from ben_actl_prem_f apr
700: where apr.oipl_id = p_oipl_id
701: and apr.prem_asnmt_cd = 'ENRT' -- PROC are dealt with in benprplc.pkb
702: and p_date
703: between apr.effective_start_date