APPS.PA_PURGE_ICIP dependencies on PA_TASKS

Line 194: from pa_tasks t,

190: TP_AMT_TYPE_CODE
191: from pa_draft_invoice_details_all
192: where expenditure_item_id in
193: ( select ei.expenditure_item_id
194: from pa_tasks t,
195: pa_expenditure_items_all ei
196: where ei.expenditure_item_date <= p_txn_to_date
197: and ei.task_id = t.task_id
198: and t.project_id = p_project_id )

Line 445: from pa_tasks t,

441:
442: /*delete from pa_mc_draft_inv_details_all mdi
443: where (mdi.draft_invoice_detail_id ) in
444: ( select did.draft_invoice_detail_id
445: from pa_tasks t,
446: pa_expenditure_items_all ei,
447: pa_draft_invoice_details_all did
448: where ei.expenditure_item_date <= p_txn_to_date
449: and ei.task_id = t.task_id

Line 486: from pa_tasks t,

482: from pa_draft_invoice_details_all did
483: where did.cc_project_id = p_project_id
484: and did.expenditure_item_id in
485: ( select ei.expenditure_item_id
486: from pa_tasks t,
487: pa_expenditure_items_all ei
488: where ei.expenditure_item_date <= p_txn_to_date
489: and ei.task_id = t.task_id
490: and t.project_id = p_project_id

Line 500: from pa_tasks t,

496: --Commenting out for bug#7701114 and taking out of loop
497: /* delete from pa_draft_invoice_details_all did
498: where (did.expenditure_item_id ) in
499: ( select ei.expenditure_item_id
500: from pa_tasks t,
501: pa_expenditure_items_all ei
502: where ei.expenditure_item_date <= p_txn_to_date
503: and ei.task_id = t.task_id
504: and t.project_id = p_project_id

Line 516: from pa_tasks t,

512:
513: /*delete from pa_mc_draft_inv_details_all mdi
514: where (mdi.draft_invoice_detail_id ) in
515: ( select did.draft_invoice_detail_id
516: from pa_tasks t,
517: pa_expenditure_items_all ei,
518: pa_draft_invoice_details_all did
519: where ei.task_id = t.task_id
520: and t.project_id = p_project_id

Line 622: from pa_tasks t,

618: IF p_txn_to_date is NOT NULL THEN
619: delete from pa_draft_invoice_details_all did
620: where (did.expenditure_item_id ) in
621: ( select ei.expenditure_item_id
622: from pa_tasks t,
623: pa_expenditure_items_all ei
624: where ei.expenditure_item_date <= p_txn_to_date
625: and ei.task_id = t.task_id
626: and t.project_id = p_project_id)

Line 637: from --pa_tasks t, /* Bug#4943324 : Perf Issue : Removed the Task table */

633:
634: delete from pa_draft_invoice_details_all did
635: where (did.expenditure_item_id ) in
636: ( select ei.expenditure_item_id
637: from --pa_tasks t, /* Bug#4943324 : Perf Issue : Removed the Task table */
638: pa_expenditure_items_all ei
639: where -- ei.task_id = t.task_id and
640: ei.project_id = p_project_id)
641: and did.cc_project_id = p_project_id