APPS.PA_CC_TP_UTILS dependencies on HR_OPERATING_UNITS

Line 55: from hr_operating_units o

51:
52: cursor c_ou is
53: select '1' from dual
54: where exists (select 'Y'
55: from hr_operating_units o
56: where o.business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id)
57: and o.organization_id=p_organization_id);
58: cursor c_le is
59: select '1' from dual

Line 161: from hr_operating_units h

157: where tp_schedule_id=p_tp_schedule_id
158: and prvdr_organization_id=p_prvdr_organization_id
159: and recvr_org_id in
160: ( select organization_id
161: from hr_operating_units h
162: where h.legal_entity_id=to_char(p_recvr_organization_id));
163:
164: elsif (v_prvdr_org_level='ORG' and v_recvr_org_level='BG') then
165: delete from pa_cc_tp_schedule_line_lkp

Line 170: from hr_operating_units h

166: where tp_schedule_id=p_tp_schedule_id
167: and prvdr_organization_id=p_prvdr_organization_id
168: and recvr_org_id in
169: (select organization_id
170: from hr_operating_units h
171: where h.business_group_id =p_recvr_organization_id);*/
172:
173: elsif (v_prvdr_org_level='ORG' and v_recvr_org_level='NULL') then
174: delete from pa_cc_tp_schedule_line_lkp

Line 192: from hr_operating_units h

188: where tp_schedule_id=p_tp_schedule_id
189: and prvdr_org_id=p_prvdr_organization_id
190: and recvr_org_id in
191: ( select organization_id
192: from hr_operating_units h
193: where h.legal_entity_id=to_char(p_recvr_organization_id));
194:
195: elsif (v_prvdr_org_level='OU' and v_recvr_org_level='BG') then
196: delete from pa_cc_tp_schedule_line_lkp

Line 201: from hr_operating_units h

197: where tp_schedule_id=p_tp_schedule_id
198: and PRVDR_ORG_ID=p_prvdr_organization_id
199: and recvr_org_id in
200: (select organization_id
201: from hr_operating_units h
202: where h.business_group_id =p_recvr_organization_id);
203:
204: elsif (v_prvdr_org_level='OU' and v_recvr_org_level='NULL') then
205: delete from pa_cc_tp_schedule_line_lkp

Line 214: from hr_operating_units h

210: delete from pa_cc_tp_schedule_line_lkp
211: where tp_schedule_id=p_tp_schedule_id
212: and prvdr_org_id in
213: (select organization_id
214: from hr_operating_units h
215: where h.legal_entity_id=to_char(p_prvdr_organization_id))
216: and recvr_org_id in
217: (select organization_id
218: from hr_operating_units h

Line 218: from hr_operating_units h

214: from hr_operating_units h
215: where h.legal_entity_id=to_char(p_prvdr_organization_id))
216: and recvr_org_id in
217: (select organization_id
218: from hr_operating_units h
219: where h.legal_entity_id=to_char(p_recvr_organization_id));
220: elsif (v_prvdr_org_level='LE' and v_recvr_org_level='BG') then
221: delete from pa_cc_tp_schedule_line_lkp
222: where tp_schedule_id=p_tp_schedule_id

Line 225: from hr_operating_units h

221: delete from pa_cc_tp_schedule_line_lkp
222: where tp_schedule_id=p_tp_schedule_id
223: and prvdr_org_id in
224: (select organization_id
225: from hr_operating_units h
226: where h.legal_entity_id=to_char(p_prvdr_organization_id))
227: and recvr_org_id in
228: (select organization_id from hr_operating_units h
229: where h.business_group_id=p_recvr_organization_id);

Line 228: (select organization_id from hr_operating_units h

224: (select organization_id
225: from hr_operating_units h
226: where h.legal_entity_id=to_char(p_prvdr_organization_id))
227: and recvr_org_id in
228: (select organization_id from hr_operating_units h
229: where h.business_group_id=p_recvr_organization_id);
230:
231: elsif (v_prvdr_org_level='LE' and v_recvr_org_level='NULL') then
232: delete from pa_cc_tp_schedule_line_lkp

Line 236: from hr_operating_units h

232: delete from pa_cc_tp_schedule_line_lkp
233: where tp_schedule_id=p_tp_schedule_id
234: and prvdr_org_id in
235: (select organization_id
236: from hr_operating_units h
237: where h.legal_entity_id =to_char(p_prvdr_organization_id));
238:
239: elsif (v_prvdr_org_level='BG' and v_recvr_org_level='BG') then
240: delete from pa_cc_tp_schedule_line_lkp

Line 244: from hr_operating_units h

240: delete from pa_cc_tp_schedule_line_lkp
241: where tp_schedule_id=p_tp_schedule_id
242: and prvdr_org_id in
243: (select organization_id
244: from hr_operating_units h
245: where h.business_group_id =p_prvdr_organization_id)
246: and recvr_org_id in
247: (select organization_id
248: from hr_operating_units h

Line 248: from hr_operating_units h

244: from hr_operating_units h
245: where h.business_group_id =p_prvdr_organization_id)
246: and recvr_org_id in
247: (select organization_id
248: from hr_operating_units h
249: where h.business_group_id =p_recvr_organization_id);
250:
251: elsif (v_prvdr_org_level='BG' and v_recvr_org_level='NULL') then
252: delete from pa_cc_tp_schedule_line_lkp

Line 256: from hr_operating_units h

252: delete from pa_cc_tp_schedule_line_lkp
253: where tp_schedule_id=p_tp_schedule_id
254: and prvdr_org_id in
255: (select organization_id
256: from hr_operating_units h
257: where h.business_group_id =p_prvdr_organization_id);
258:
259: Move the end of comment from here to the end for bug 4654754
260: --

Line 271: from hr_operating_units h

267: delete from pa_cc_tp_schedule_line_lkp
268: where tp_schedule_id=p_tp_schedule_id
269: and prvdr_org_id in
270: (select organization_id
271: from hr_operating_units h
272: where h.business_group_id =p_prvdr_organization_id)
273: and recvr_org_id in
274: (select organization_id
275: from hr_operating_units h

Line 275: from hr_operating_units h

271: from hr_operating_units h
272: where h.business_group_id =p_prvdr_organization_id)
273: and recvr_org_id in
274: (select organization_id
275: from hr_operating_units h
276: where h.legal_entity_id= to_char(p_prvdr_organization_id));
277:
278: elsif (v_prvdr_org_level = 'BG' and v_recvr_org_level = 'OU') then
279: delete from pa_cc_tp_schedule_line_lkp

Line 283: from hr_operating_units h

279: delete from pa_cc_tp_schedule_line_lkp
280: where tp_schedule_id=p_tp_schedule_id
281: and prvdr_org_id in
282: (select organization_id
283: from hr_operating_units h
284: where h.business_group_id =p_prvdr_organization_id)
285: and recvr_org_id =p_recvr_organization_id;
286:
287: elsif (v_prvdr_org_level = 'BG' and v_recvr_org_level = 'ORG') then

Line 292: from hr_operating_units h

288: delete from pa_cc_tp_schedule_line_lkp
289: where tp_schedule_id=p_tp_schedule_id
290: and prvdr_org_id in
291: (select organization_id
292: from hr_operating_units h
293: where h.business_group_id =p_prvdr_organization_id)
294: and recvr_organization_id =p_recvr_organization_id;
295:
296: elsif (v_prvdr_org_level = 'LE' and v_recvr_org_level = 'OU') then

Line 301: from hr_operating_units h

297: delete from pa_cc_tp_schedule_line_lkp
298: where tp_schedule_id=p_tp_schedule_id
299: and prvdr_org_id in
300: (select organization_id
301: from hr_operating_units h
302: where h.legal_entity_id=to_char(p_prvdr_organization_id))
303: and recvr_org_id = p_recvr_organization_id ;
304: elsif (v_prvdr_org_level = 'LE' and v_recvr_org_level = 'ORG') then
305: delete from pa_cc_tp_schedule_line_lkp

Line 309: from hr_operating_units h

305: delete from pa_cc_tp_schedule_line_lkp
306: where tp_schedule_id=p_tp_schedule_id
307: and prvdr_org_id in
308: (select organization_id
309: from hr_operating_units h
310: where h.legal_entity_id=to_char(p_prvdr_organization_id))
311: and recvr_organization_id = p_recvr_organization_id ;
312: elsif (v_prvdr_org_level = 'OU' and v_recvr_org_level = 'ORG') then
313: delete from pa_cc_tp_schedule_line_lkp

Line 429: from hr_operating_units

425:
426: cursor c_ou is
427: select '1' from dual
428: where exists (select 'Y'
429: from hr_operating_units
430: where organization_id=p_organization_id
431: and business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id));
432: cursor c_le is
433: select '1' from dual