APPS.PA_BILL_PCT dependencies on PA_DRAFT_INVOICE_ITEMS

Line 867: from pa_draft_invoice_items pdii

863: AND nvl(e.task_id,0) = decode(X2_task_id,
864: NULL, nvl(e.task_id,0), X2_task_id)
865: AND NOT EXISTS
866: (select 'billed'
867: from pa_draft_invoice_items pdii
868: where pdii.project_id = e.project_id
869: and pdii.event_num = e.event_num
870: and nvl(pdii.task_id,0) = nvl(e.task_id,0));
871:

Line 895: from pa_draft_invoice_items pdii

891: and nvl(e.task_id,0) = decode(X2_task_id,
892: NULL, nvl(e.task_id,0), X2_task_id)
893: and NOT EXISTS
894: (select 'billed'
895: from pa_draft_invoice_items pdii
896: where pdii.project_id = e.project_id
897: and pdii.event_num = e.event_num
898: and nvl(pdii.task_id,0) = nvl(e.task_id,0)); */
899:

Line 970: FROM pa_draft_invoice_items dii

966:
967: /* Change this column from amount to projfunc_bill_amount for MCB2 */
968: SELECT sum(nvl(dii.projfunc_bill_amount,0))
969: INTO billed_ccinv
970: FROM pa_draft_invoice_items dii
971: WHERE dii.project_id = X2_project_id
972: AND (EXISTS (select '1'
973: from pa_events e,
974: pa_billing_assignments bea,

Line 1014: FROM pa_draft_invoice_items pdii

1010: END IF;
1011: /* Change this column from amount to projfunc_bill_amount for MCB2 */
1012: SELECT sum(nvl(pdii.projfunc_bill_amount,0))
1013: INTO task_billed_ev_ccinv
1014: FROM pa_draft_invoice_items pdii
1015: WHERE pdii.event_task_id = X2_task_id
1016: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695332
1017: AND EXISTS (select '1'
1018: from pa_events e,