DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_DRAFT_REVENUE_ITEMS

Line 686: FROM pa_draft_revenue_items dri

682: -- Percent Complete Revenue that has been accrued.
683: /* change this column from amount to projfunc_revenue_amount for MCB2 */
684: SELECT sum(nvl(dri.projfunc_revenue_amount,0))
685: INTO accrued_pctrev
686: FROM pa_draft_revenue_items dri
687: WHERE dri.project_id = X2_project_id
688: AND nvl(dri.task_id,0) = decode(X2_task_id, NULL, nvl(dri.task_id,0), X2_task_id )
689: AND (EXISTS ( select '1'
690: from pa_cust_event_rev_dist_lines erdl,