APPS.PO_PERSON dependencies on DUAL

Line 25: from sys.dual

21: --
22: begin
23: select 'Y'
24: into v_delete_permitted
25: from sys.dual
26: where not exists (
27: select null
28: from po_vendors pov
29: where pov.employee_id = P_PERSON_ID);

Line 41: from sys.dual

37: --
38: begin
39: select 'Y'
40: into v_delete_permitted
41: from sys.dual
42: where not exists (
43: select null
44: from hr_locations hr
45: where hr.designated_receiver_id = P_PERSON_ID);

Line 57: from sys.dual

53: --
54: begin
55: select 'Y'
56: into v_delete_permitted
57: from sys.dual
58: where not exists (
59: select null
60: from po_agents po
61: where po.agent_id = P_PERSON_ID);

Line 73: from sys.dual

69: --
70: begin
71: select 'Y'
72: into v_delete_permitted
73: from sys.dual
74: where not exists (
75: select null
76: from po_acceptances po
77: where po.employee_id = P_PERSON_ID);

Line 89: from sys.dual

85: --
86: begin
87: select 'Y'
88: into v_delete_permitted
89: from sys.dual
90: where not exists (
91: select null
92: from po_quotation_approvals_all po
93: where po.approver_id = P_PERSON_ID);

Line 105: from sys.dual

101: --
102: begin
103: select 'Y'
104: into v_delete_permitted
105: from sys.dual
106: where not exists (
107: select null
108: from po_headers_all po
109: where po.agent_id = P_PERSON_ID)

Line 125: from sys.dual

121: --
122: begin
123: select 'Y'
124: into v_delete_permitted
125: from sys.dual
126: where not exists (
127: select null
128: from po_distributions_all po
129: where po.deliver_to_person_id = P_PERSON_ID)

Line 147: from sys.dual

143: null;
144: /* po_notifications_all is obsolete in R11
145: select 'Y'
146: into v_delete_permitted
147: from sys.dual
148: where not exists (
149: select null
150: from po_notifications_all po
151: where po.employee_id = P_PERSON_ID);

Line 164: from sys.dual

160: --
161: begin
162: select 'Y'
163: into v_delete_permitted
164: from sys.dual
165: where not exists (
166: select null
167: from po_releases_all po
168: where po.agent_id = P_PERSON_ID

Line 188: from sys.dual

184: --
185: begin
186: select 'Y'
187: into v_delete_permitted
188: from sys.dual
189: where not exists (
190: select null
191: from po_requisitions_interface_all po
192: where po.approver_id = P_PERSON_ID

Line 207: from sys.dual

203: --
204: begin
205: select 'Y'
206: into v_delete_permitted
207: from sys.dual
208: where not exists (
209: select null
210: from po_requisition_headers_all po
211: where po.preparer_id = P_PERSON_ID);

Line 223: from sys.dual

219: --
220: begin
221: select 'Y'
222: into v_delete_permitted
223: from sys.dual
224: where not exists (
225: select null
226: from po_requisition_lines_all po
227: where po.to_person_id = P_PERSON_ID

Line 241: from sys.dual

237: --
238: begin
239: select 'Y'
240: into v_delete_permitted
241: from sys.dual
242: where not exists (
243: select null
244: from po_action_history po
245: where po.employee_id = P_PERSON_ID);

Line 257: from sys.dual

253: --
254: begin
255: select 'Y'
256: into v_delete_permitted
257: from sys.dual
258: where not exists (
259: select null
260: from po_employee_hierarchies po
261: where po.employee_id = P_PERSON_ID

Line 274: from sys.dual

270: --
271: begin
272: select 'Y'
273: into v_delete_permitted
274: from sys.dual
275: where not exists (
276: select null
277: from po_lines_all po
278: where po.cancelled_by = P_PERSON_ID

Line 296: from sys.dual

292: --
293: begin
294: select 'Y'
295: into v_delete_permitted
296: from sys.dual
297: where not exists (
298: select null
299: from po_line_locations_all po
300: where po.cancelled_by = P_PERSON_ID

Line 318: from sys.dual

314: --
315: begin
316: select 'Y'
317: into v_delete_permitted
318: from sys.dual
319: where not exists (
320: select null
321: from po_reqexpress_lines_all po
322: where po.suggested_buyer_id = P_PERSON_ID);