DBA Data[Home] [Help]

APPS.BEN_PLAN_IN_PROGRAM_API dependencies on BEN_OIPL_F

Line 115: from ben_oipl_f cop

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

Line 128: ben_oipl_f oipl,

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