DBA Data[Home] [Help]

APPS.BEN_ABR_UPD dependencies on BEN_PLIP_F

Line 449: from ben_plip_f

445: l_oipl c_oipl%rowtype;
446: --
447: cursor c_plip is
448: select pgm_id, pl_id
449: from ben_plip_f
450: where plip_id = p_rec.plip_id
451: and p_effective_date between effective_start_date and effective_end_date;
452: --
453: l_plip c_plip%rowtype;

Line 457: from ben_oiplip_f oiplip, ben_oipl_f oipl, ben_plip_f plip

453: l_plip c_plip%rowtype;
454: --
455: cursor c_oiplip is
456: select plip.pgm_id, oipl.pl_id, oipl.opt_id
457: from ben_oiplip_f oiplip, ben_oipl_f oipl, ben_plip_f plip
458: where oiplip.oiplip_id = p_rec.oiplip_id
459: and oiplip.oipl_id = oipl.oipl_id
460: and oiplip.plip_id = plip.plip_id
461: and oipl.pl_id = plip.pl_id