DBA Data[Home] [Help]

APPS.BEN_OPTION_IN_PLAN_API dependencies on BEN_PL_F

Line 108: ben_pl_f pl

104: ptip.ptip_id
105: from
106: ben_ptip_f ptip,
107: ben_plip_f plip,
108: ben_pl_f pl
109: where
110: pl.pl_id = p_pl_id
111: and plip.pl_id = pl.pl_id
112: and pl.business_group_id = p_business_group_id

Line 939: ben_pl_f pl,

935: pl.pl_id,
936: pl.pl_typ_id
937: from
938: ben_plip_f plip,
939: ben_pl_f pl,
940: ben_oipl_f oipl
941: where
942: oipl.oipl_id = p_oipl_id
943: and oipl.pl_id = pl.pl_id

Line 970: ben_pl_f pl,

966: and p_effective_date between otp.effective_start_date and otp.effective_end_date -- Bug 3023622
967: and not exists ( select null
968: from
969: ben_plip_f plip,
970: ben_pl_f pl,
971: ben_oipl_f oipl
972: where -- plip.business_group_id = p_business_group_id
973: plip.pgm_id = p_pgm_id
974: and pl.pl_typ_id = p_pl_typ_id