APPS.PA_BILLING_AMOUNT dependencies on PA_CUST_REV_DIST_LINES

Line 720: from pa_cust_rev_dist_lines erdl

716: and dii.event_num = e.event_num
717: and nvl(dii.event_task_id,0) = nvl(e.task_id,0)
718: and be.procedure_name = 'pa_billing.ccrev')
719: OR EXISTS ( select '1'
720: from pa_cust_rev_dist_lines erdl
721: where erdl.project_id = dii.project_id
722: and erdl.draft_invoice_num = dii.draft_invoice_num
723: and erdl.draft_invoice_item_line_num = dii.line_num));
724:

Line 735: FROM pa_cust_rev_dist_lines rdl,

731:
732: /* Change this column from amount to projfunc_bill_amount for MCB2 */
733: SELECT sum(nvl(rdl.projfunc_bill_amount,0))
734: INTO task_billed_ccinv
735: FROM pa_cust_rev_dist_lines rdl,
736: pa_expenditure_items_all ei,
737: pa_tasks t
738: WHERE ei.task_id = t.task_id
739: AND ei.expenditure_item_id = rdl.expenditure_item_id

Line 1043: FROM pa_cust_rev_dist_lines rdl

1039: /* Changed column from bill_amount to projfunc_bill_amount and amount to projfunc_revenue_amount for MCB2 */
1040: SELECT sum(decode(X_which, 'I', nvl(rdl.projfunc_bill_amount,0),
1041: 'R', NVL(rdl.projfunc_revenue_amount,0),NVL(rdl.projfunc_revenue_amount,0)))
1042: INTO Ramount
1043: FROM pa_cust_rev_dist_lines rdl
1044: WHERE rdl.expenditure_item_id = X_eiid
1045: AND (X_adj = 'ADJ'
1046: AND (rdl.line_num_reversed IS NOT NULL
1047: OR X_ei_adj = 'Y')