APPS.PA_PURGE_ICIP dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 195: pa_expenditure_items_all ei

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 )
199: and rownum <= l_commit_size;

Line 334: pa_expenditure_items_all ei

330: from pa_draft_invoice_details_all
331: where expenditure_item_id in
332: ( select ei.expenditure_item_id /* Bug#4943324 : Perf Issue : Removed the Task table */
333: from
334: pa_expenditure_items_all ei
335: where ei.project_id = p_project_id )
336: and rownum <= l_commit_size;
337: end if;
338:

Line 446: pa_expenditure_items_all ei,

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
450: and t.project_id = p_project_id

Line 462: pa_expenditure_items_all ei

458: delete from pa_mc_draft_inv_details_all mdi where
459: mdi.set_of_books_id > 0
460: and exists
461: (select 1 from pa_draft_invoice_details_all did,
462: pa_expenditure_items_all ei
463: where ei.expenditure_item_id = did.expenditure_item_id
464: and ei.project_id = p_project_id
465: and ei.expenditure_item_date <= p_txn_to_date
466: and did.draft_invoice_detail_id = mdi.draft_invoice_detail_id)

Line 487: pa_expenditure_items_all ei

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
491: )

Line 499: pa_expenditure_items_all ei

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
503: )

Line 515: pa_expenditure_items_all ei,

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
519: and t.project_id = did.project_id

Line 530: pa_expenditure_items_all ei

526: delete from pa_mc_draft_inv_details_all mdi where
527: mdi.set_of_books_id > 0
528: and exists
529: (select 1 from pa_draft_invoice_details_all did,
530: pa_expenditure_items_all ei
531: where ei.expenditure_item_id = did.expenditure_item_id
532: and ei.project_id = p_project_id
533: and did.draft_invoice_detail_id = mdi.draft_invoice_detail_id)
534: and rownum < l_pmy_commit_size;

Line 559: from pa_expenditure_items_all ei

555:
556: delete from pa_draft_invoice_details_all did
557: where (did.expenditure_item_id ) in
558: ( select ei.expenditure_item_id /* Bug#4943324 : Perf Issue : Removed the Task table */
559: from pa_expenditure_items_all ei
560: where ei.project_id = p_project_id
561: )
562: and did.cc_project_id = p_project_id
563: and rownum < l_commit_size;