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 498: from pa_tasks t,

494:
495: delete from pa_draft_invoice_details_all did
496: where (did.expenditure_item_id ) in
497: ( select ei.expenditure_item_id
498: from pa_tasks t,
499: pa_expenditure_items_all ei
500: where ei.expenditure_item_date <= p_txn_to_date
501: and ei.task_id = t.task_id
502: and t.project_id = p_project_id

Line 514: from pa_tasks t,

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