APPS.BEN_OPTION_IN_PLAN_API dependencies on BEN_PLIP_F

Line 93: from ben_plip_f cpp

89: -- Declare cursors and local variables
90: --
91: cursor c_cpp is
92: select cpp.plip_id
93: from ben_plip_f cpp
94: where cpp.pl_id = p_pl_id
95: and cpp.business_group_id + 0 = p_business_group_id
96: and p_effective_date between
97: cpp.effective_start_date and cpp.effective_end_date;

Line 106: ben_plip_f plip,

102: pl.pl_typ_id,
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

Line 930: ben_plip_f plip,

926: plip.pgm_id,
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

Line 961: ben_plip_f plip,

957: -- and otp.business_group_id = p_business_group_id
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