DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_PTIP_F

Line 1349: from ben_ptip_f ctp,ben_pl_f pl

1345: and cpp.effective_end_date;
1346: --
1347: cursor c_get_pl_from_ptip(c_effective_date date) is
1348: select pl.pl_id
1349: from ben_ptip_f ctp,ben_pl_f pl
1350: where ctp.ptip_id = p_ptip_id
1351: and pl.pl_typ_id = ctp.pl_typ_id
1352: and c_effective_date
1353: between ctp.effective_start_date