APPS.PA_PERSON dependencies on DUAL

Line 125: from sys.dual

121: per_delete_allowed varchar2(1);
122: BEGIN
123: select 'X'
124: into per_delete_allowed
125: from sys.dual
126: where not exists (
127: select null
128: from pa_implementations_all imp,
129: per_all_people_f per

Line 170: from sys.dual

166: --
167: begin
168: select 'Y'
169: into v_delete_permitted
170: from sys.dual
171: where not exists (
172: select null
173: from pa_compensation_details pa
174: where pa.person_id = P_PERSON_ID);

Line 186: from sys.dual

182: --
183: begin
184: select 'Y'
185: into v_delete_permitted
186: from sys.dual
187: where not exists (
188: select null
189: from pa_emp_bill_rate_overrides pa
190: where pa.project_id > -1

Line 204: from sys.dual

200: --
201: begin
202: select 'Y'
203: into v_delete_permitted
204: from sys.dual
205: where not exists (
206: select null
207: from pa_job_assignment_overrides pa
208: where ((pa.project_id > -1 AND

Line 224: from sys.dual

220: --
221: begin
222: select 'Y'
223: into v_delete_permitted
224: from sys.dual
225: where not exists (
226: select /*+ INDEX ( pa PA_BILL_RATES_U1 ) */
227: null
228: from pa_bill_rates pa

Line 243: from sys.dual

239: --
240: begin
241: select 'Y'
242: into v_delete_permitted
243: from sys.dual
244: where not exists (
245: select null
246: from pa_project_players pa
247: where pa.person_id = P_PERSON_ID);

Line 259: from sys.dual

255: --
256: begin
257: select 'Y'
258: into v_delete_permitted
259: from sys.dual
260: where not exists (
261: select null
262: from pa_agreements pa
263: where pa.owned_by_person_id = P_PERSON_ID);

Line 275: from sys.dual

271: --
272: begin
273: select 'Y'
274: into v_delete_permitted
275: from sys.dual
276: where not exists (
277: select null
278: from pa_tasks pa
279: where pa.task_manager_person_id = P_PERSON_ID);

Line 292: from sys.dual

288: begin
289: select /*+ INDEX (pa PA_CREDIT_RECEIVERS_U1) */
290: 'Y'
291: into v_delete_permitted
292: from sys.dual
293: where not exists (
294: select null
295: from pa_credit_receivers pa
296: where pa.person_id = P_PERSON_ID);

Line 308: from sys.dual

304: --
305: begin
306: select 'Y'
307: into v_delete_permitted
308: from sys.dual
309: where not exists (
310: select null
311: from pa_expenditures pa
312: where pa.incurred_by_person_id = P_PERSON_ID);

Line 316: from sys.dual

312: where pa.incurred_by_person_id = P_PERSON_ID);
313:
314: select 'Y'
315: into v_delete_permitted
316: from sys.dual
317: where not exists (
318: select null
319: from pa_expenditures pa
320: where pa.entered_by_person_id = P_PERSON_ID);

Line 332: from sys.dual

328: --
329: begin
330: select 'Y'
331: into v_delete_permitted
332: from sys.dual
333: where not exists (
334: select null
335: from pa_draft_invoices pa
336: where pa.approved_by_person_id = P_PERSON_ID

Line 353: from sys.dual

349: --
350: begin
351: select 'Y'
352: into v_delete_permitted
353: from sys.dual
354: where not exists (
355: select null
356: from pa_employee_accum pa
357: where pa.person_id = P_PERSON_ID);

Line 371: from sys.dual

367: --
368: begin
369: select 'Y'
370: into v_delete_permitted
371: from sys.dual
372: where not exists (
373: select null
374: from pa_routings pa
375: where (pa.routed_to_person_id = P_PERSON_ID

Line 389: from sys.dual

385: --
386: begin
387: select 'Y'
388: into v_delete_permitted
389: from sys.dual
390: where not exists (
391: select null
392: from pa_transaction_controls pa
393: where pa.project_id > -1