DBA Data[Home] [Help]

APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_SUMMARY_PROJECT_RETN

Line 559: FROM pa_summary_project_retn

555: ,SUM(NVL(projfunc_total_retained,0)) - SUM(NVL(projfunc_total_billed,0)) Projfunc_Unbilled_Retn
556: INTO
557: l_proj_unbilled_retn
558: ,l_projfunc_unbilled_retn
559: FROM pa_summary_project_retn
560: WHERE project_id = p_project_id;
561:
562: -- Calculating total unapproved invoice amount in project functional currency
563: -- and project currency