DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_OIPLIP_F

Line 10105: from ben_oiplip_f opp, ben_oipl_f cop

10101: --
10102: cursor c_get_oiplip_opt_id (cv_oipl_id number,
10103: cv_plip_id number) is
10104: select opp.oiplip_id, opt_id
10105: from ben_oiplip_f opp, ben_oipl_f cop
10106: where opp.oipl_id = cv_oipl_id
10107: and opp.plip_id = cv_plip_id
10108: and p_effective_date between opp.effective_start_date and opp.effective_end_date
10109: and cop.oipl_id = opp.oipl_id