[Home] [Help]
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;
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:
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
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)
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: )
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
505: )
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
521: and t.project_id = did.project_id
528: delete from pa_mc_draft_inv_details_all mdi where
529: mdi.set_of_books_id > 0
530: and exists
531: (select 1 from pa_draft_invoice_details_all did,
532: pa_expenditure_items_all ei
533: where ei.expenditure_item_id = did.expenditure_item_id
534: and ei.project_id = p_project_id
535: and did.draft_invoice_detail_id = mdi.draft_invoice_detail_id)
536: and rownum < l_pmy_commit_size;
558: --Commenting out for bug#7701114 and taking out of loop
559: /*delete from pa_draft_invoice_details_all did
560: where (did.expenditure_item_id ) in
561: ( select ei.expenditure_item_id /* Bug#4943324 : Perf Issue : Removed the Task table
562: from pa_expenditure_items_all ei
563: where ei.project_id = p_project_id
564: )
565: and did.cc_project_id = p_project_id
566: and rownum < l_commit_size;
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)
627: and did.cc_project_id = p_project_id
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
642: and rownum < l_commit_size;