DBA Data[Home] [Help]

APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on BEN_OIPL_F

Line 97: from ben_oipl_f oipl

93:
94:
95: cursor c_oipl(v_pl_id number) is
96: select distinct oipl.oipl_id
97: from ben_oipl_f oipl
98: where oipl.pl_id = v_pl_id;
99:
100: cursor c_pl_dsgn is
101: select enp.enrt_perd_id

Line 180: from ben_oipl_f oipl

176: and abr.sub_acty_typ_cd is null
177: and (abr.pl_id = l_pl_dsgn.pl_id
178: OR
179: abr.oipl_id in (select oipl.oipl_id
180: from ben_oipl_f oipl
181: where oipl.pl_id = l_pl_dsgn.pl_id));
182: exception
183: -- No data found.
184: when others then