DBA Data[Home] [Help]

APPS.BEN_GLOBAL_FUNCTIONS dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 517: from ben_actl_prem_vrbl_rt_f apv

513: cursor c_get_acp_par_pgmpl_id(p_vpf_id number) is
514: select ben_global_functions.get_par_pgm_id
515: (null,null,apr.pl_id,null,apr.oipl_id,null) pgm_id,
516: ben_global_functions.get_par_plnip_id(apr.pl_id,apr.oipl_id) pl_id
517: from ben_actl_prem_vrbl_rt_f apv
518: , ben_actl_prem_f apr
519: where apv.vrbl_rt_prfl_id = p_vpf_id
520: and apv.actl_prem_id = apr.actl_prem_id
521: and apv.effective_start_date between apr.effective_start_date