DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 785: from ben_cvg_amt_calc_mthd_f ccm,

781: (c_effective_date in date
782: )
783: is
784: select ccm.cvg_amt_calc_mthd_id
785: from ben_cvg_amt_calc_mthd_f ccm,
786: ben_pl_f pln
787: where pln.pl_id = l_epe.pl_id
788: and pln.pl_id = ccm.pl_id
789: and c_effective_date

Line 801: from ben_cvg_amt_calc_mthd_f ccm,

797: (c_effective_date in date
798: )
799: is
800: select ccm.cvg_amt_calc_mthd_id
801: from ben_cvg_amt_calc_mthd_f ccm,
802: ben_oipl_f cop
803: where cop.oipl_id = l_epe.oipl_id
804: and cop.oipl_id = ccm.oipl_id
805: and c_effective_date