DBA Data[Home] [Help]

APPS.BEN_PLAN_IN_PROGRAM_API dependencies on BEN_OIPL_F

Line 116: from ben_oipl_f cop

112: -- Declare cursors and local variables
113: --
114: cursor c_cop is
115: select cop.oipl_id
116: from ben_oipl_f cop
117: where cop.pl_id = p_pl_id
118: and cop.business_group_id + 0 = p_business_group_id
119: and p_effective_date between
120: cop.effective_start_date and cop.effective_end_date;

Line 129: ben_oipl_f oipl,

125: pl.pl_typ_id,
126: ptip.ptip_id,
127: oipl.opt_id
128: from
129: ben_oipl_f oipl,
130: ben_ptip_f ptip,
131: ben_plip_f plip,
132: ben_pl_f pl
133: where