DBA Data[Home] [Help]

APPS.BEN_GLOBAL_FUNCTIONS dependencies on BEN_BNFT_VRBL_RT_F

Line 506: from ben_bnft_vrbl_rt_f bvr

502: cursor c_get_cvg_par_pgmpl_id(p_vpf_id number) is
503: select ben_global_functions.get_par_pgm_id
504: (null,null,ccm.pl_id,ccm.plip_id,ccm.oipl_id,null) pgm_id,
505: ben_global_functions.get_par_plnip_id(ccm.pl_id,ccm.oipl_id) nip_id
506: from ben_bnft_vrbl_rt_f bvr
507: , ben_cvg_amt_calc_mthd_f ccm
508: where bvr.vrbl_rt_prfl_id = p_vpf_id
509: and bvr.cvg_amt_calc_mthd_id = ccm.cvg_amt_calc_mthd_id
510: and bvr.effective_start_date between ccm.effective_start_date