APPS.PA_BILLING_AMOUNT dependencies on PA_DRAFT_INVOICE_ITEMS

Line 602: from pa_draft_invoice_items pdii

598: AND nvl(e.task_id,0) = decode(X2_task_id,
599: NULL, nvl(e.task_id,0), X2_task_id)
600: AND NOT EXISTS
601: (select 'billed'
602: from pa_draft_invoice_items pdii
603: where pdii.project_id = e.project_id
604: and pdii.event_num = e.event_num
605: and nvl(pdii.task_id,0) = nvl(e.task_id,0));
606:

Line 632: from pa_draft_invoice_items pdii

628: and nvl(e.task_id,0) = decode(X2_task_id,
629: NULL, nvl(e.task_id,0), X2_task_id)
630: and NOT EXISTS
631: (select 'billed'
632: from pa_draft_invoice_items pdii
633: where pdii.project_id = e.project_id
634: and pdii.event_num = e.event_num
635: and nvl(pdii.task_id,0) = nvl(e.task_id,0)); */
636:

Line 707: FROM pa_draft_invoice_items dii

703:
704: /* change this column from amount to projfunc_bill_amount for MCB2 */
705: SELECT sum(nvl(dii.projfunc_bill_amount,0))
706: INTO billed_ccinv
707: FROM pa_draft_invoice_items dii
708: WHERE dii.project_id = X2_project_id
709: AND (EXISTS (select '1'
710: from pa_events e,
711: pa_billing_assignments bea,

Line 747: FROM pa_draft_invoice_items pdii

743:
744: /* Change this column from amount to projfunc_bill_amount for MCB2 */
745: SELECT sum(nvl(pdii.projfunc_bill_amount,0))
746: INTO task_billed_ev_ccinv
747: FROM pa_draft_invoice_items pdii
748: WHERE pdii.event_task_id = X2_task_id
749: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695243
750: AND EXISTS (select '1'
751: from pa_events e,

Line 836: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii

832: SELECT DECODE(e.revenue_distributed_flag,'N', NVL(e.bill_trans_rev_amount,0),0) trans_rev_amount,
833: DECODE(pdii.event_num,NULL, NVL(e.bill_trans_bill_amount,0),0) trans_bill_amount,
834: e.bill_trans_currency_code,
835: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
836: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii
837: WHERE e.project_id = X2_project_id
838: AND pdii.project_id (+)= e.project_id
839: AND pdii.event_num (+)= e.event_num
840: AND nvl(pdii.event_task_id,0) = nvl(e.task_id,0)

Line 863: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii

859: sum(decode(pdii.event_num,
860: NULL, nvl(e.bill_amount,0),
861: 0))
862: INTO current_event_revenue, current_event_invoice
863: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii
864: WHERE e.project_id = X2_project_id
865: AND pdii.project_id (+)= e.project_id
866: and pdii.event_num (+)= e.event_num
867: and nvl(pdii.event_task_id,0) = nvl(e.task_id,0)