DBA Data[Home] [Help]

APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_ACTL_PREM_F

Line 487: from ben_actl_prem_f apr

483: apr.val, apr.uom, apr.pl_id, apr.oipl_id, apr.bnft_rt_typ_cd,
484: apr.rndg_cd, apr.rndg_rl, apr.upr_lmt_calc_rl, apr.upr_lmt_val,
485: apr.lwr_lmt_calc_rl, apr.lwr_lmt_val, apr.prsptv_r_rtsptv_cd,
486: apr.mlt_cd, apr.cost_allocation_keyflex_id, apr.vrbl_rt_add_on_calc_rl
487: from ben_actl_prem_f apr
488: where apr.actl_prem_id = p_actl_prem_id
489: and p_effective_date between
490: apr.effective_start_date and apr.effective_end_date;
491: l_prems c_prems%rowtype;