eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_SUMMARY_PROJECT_RETN

Line 501: FROM pa_summary_project_retn

497: ,SUM(NVL(projfunc_total_retained,0)) - SUM(NVL(projfunc_total_billed,0)) Projfunc_Unbilled_Retn
498: INTO
499: l_proj_unbilled_retn
500: ,l_projfunc_unbilled_retn
501: FROM pa_summary_project_retn
502: WHERE project_id = p_project_id;
503:
504: -- Calculating total unapproved invoice amount in project functional currency
505: -- and project currency