APPS.BEN_GLOBAL_FUNCTIONS dependencies on BEN_PLIP_F

Line 40: from ben_plip_f cpp

36: from ben_pl_f pln
37: where pln.pl_id = c_pl_id
38: and not exists
39: (select null
40: from ben_plip_f cpp
41: where pln.pl_id = cpp.pl_id);
42:
43: cursor c_oiplnip
44: (c_oipl_id in number

Line 52: from ben_plip_f cpp

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
53: where cop.pl_id = cpp.pl_id);
54:
55: l_dummy varchar2(1);
56: l_return varchar2(1);

Line 111: from ben_plip_f cpp

107: from ben_pl_f pln
108: where pln.pl_id = c_pl_id
109: and not exists
110: (select null
111: from ben_plip_f cpp
112: where pln.pl_id = cpp.pl_id);
113:
114: cursor c_oiplnip
115: (c_oipl_id in number

Line 123: from ben_plip_f cpp

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
124: where cop.pl_id = cpp.pl_id);
125:
126: cursor c_opt_id
127: (c_opt_id in number

Line 135: from ben_plip_f

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
136: where cop.pl_id = cop.pl_id)
137: order by pl_id;
138:
139: l_return number;

Line 193: ben_plip_f cpp

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:
197: cursor c_oiplip

Line 203: ben_plip_f cpp

199: )
200: is
201: select cpp.pgm_id
202: from ben_oiplip_f opp,
203: ben_plip_f cpp
204: where opp.oiplip_id = c_oiplip_id
205: and opp.plip_id = cpp.plip_id;
206:
207: cursor c_pl

Line 212: from ben_plip_f cpp

208: (c_pl_id in number
209: )
210: is
211: select cpp.pgm_id
212: from ben_plip_f cpp
213: where cpp.pl_id = c_pl_id;
214:
215: cursor c_plip
216: (c_plip_id in number

Line 220: from ben_plip_f cpp

216: (c_plip_id in number
217: )
218: is
219: select cpp.pgm_id
220: from ben_plip_f cpp
221: where cpp.plip_id = c_plip_id;
222:
223: cursor c_ptip
224: (c_ptip_id in number

Line 237: ben_plip_f cpp

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;
241: