APPS.BEN_GLOBAL_FUNCTIONS dependencies on BEN_OIPL_F

Line 48: from ben_oipl_f cop

44: (c_oipl_id in number
45: )
46: is
47: select null
48: from ben_oipl_f cop
49: where cop.oipl_id = c_oipl_id
50: and not exists
51: (select null
52: from ben_plip_f cpp

Line 119: from ben_oipl_f cop

115: (c_oipl_id in number
116: )
117: is
118: select cop.pl_id
119: from ben_oipl_f cop
120: where cop.oipl_id = c_oipl_id
121: and not exists
122: (select null
123: from ben_plip_f cpp

Line 131: from ben_oipl_f cop

127: (c_opt_id in number
128: )
129: is
130: select pl_id
131: from ben_oipl_f cop
132: where cop.opt_id = c_opt_id
133: and not exists
134: (select null
135: from ben_plip_f

Line 192: from ben_oipl_f cop,

188: (c_oipl_id in number
189: )
190: is
191: select cpp.pgm_id
192: from ben_oipl_f cop,
193: ben_plip_f cpp
194: where cop.oipl_id = c_oipl_id
195: and cop.pl_id = cpp.pl_id;
196:

Line 236: from ben_oipl_f cop,

232: (c_opt_id in number
233: )
234: is
235: select cpp.pgm_id
236: from ben_oipl_f cop,
237: ben_plip_f cpp
238: where cop.opt_id = c_opt_id
239: and cpp.pl_id = cop.pl_id
240: order by cop.oipl_id, cpp.pl_id;