APPS.BEN_LBR_BUS dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 767: select null from ben_cvg_amt_calc_mthd_f cvg

763: l_api_updating boolean;
764: l_dummy varchar2(1);
765: --
766: cursor c1 is
767: select null from ben_cvg_amt_calc_mthd_f cvg
768: where nvl(cvg.pl_id,-1) = p_pl_id
769: and cvg.cvg_mlt_cd = 'FLFX'
770: and cvg.entr_val_at_enrt_flag = 'Y'
771: and cvg.business_group_id = p_business_group_id

Line 776: from ben_cvg_amt_calc_mthd_f cvg

772: and p_effective_date between cvg.effective_start_date and cvg.effective_end_date;
773: --
774: cursor c2 is
775: select null
776: from ben_cvg_amt_calc_mthd_f cvg
777: ,ben_plip_f cpp
778: ,ben_pl_f pln
779: where cvg.cvg_mlt_cd = 'FLFX'
780: and cvg.entr_val_at_enrt_flag = 'Y'