DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_OIPLIP_F

Line 10580: from ben_oiplip_f opp, ben_oipl_f cop

10576: --
10577: cursor c_get_oiplip_opt_id (cv_oipl_id number,
10578: cv_plip_id number) is
10579: select opp.oiplip_id, opt_id
10580: from ben_oiplip_f opp, ben_oipl_f cop
10581: where opp.oipl_id = cv_oipl_id
10582: and opp.plip_id = cv_plip_id
10583: and p_effective_date between opp.effective_start_date and opp.effective_end_date
10584: and cop.oipl_id = opp.oipl_id