APPS.PA_BILL_PCT dependencies on PA_DRAFT_INVOICE_ITEMS

Line 869: from pa_draft_invoice_items pdii

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

Line 897: from pa_draft_invoice_items pdii

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

Line 972: FROM pa_draft_invoice_items dii

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

Line 1016: FROM pa_draft_invoice_items pdii

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