DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_DRAFT_REVENUE_ITEMS

Line 688: FROM pa_draft_revenue_items dri

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