DBA Data[Home] [Help]

APPS.BEN_OPTION_IN_PLAN_API dependencies on BEN_PL_F

Line 107: ben_pl_f pl

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

Line 931: ben_pl_f pl,

927: pl.pl_id,
928: pl.pl_typ_id
929: from
930: ben_plip_f plip,
931: ben_pl_f pl,
932: ben_oipl_f oipl
933: where
934: oipl.oipl_id = p_oipl_id
935: and oipl.pl_id = pl.pl_id

Line 962: ben_pl_f pl,

958: and p_effective_date between otp.effective_start_date and otp.effective_end_date -- Bug 3023622
959: and not exists ( select null
960: from
961: ben_plip_f plip,
962: ben_pl_f pl,
963: ben_oipl_f oipl
964: where -- plip.business_group_id = p_business_group_id
965: plip.pgm_id = p_pgm_id
966: and pl.pl_typ_id = p_pl_typ_id