APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_SUMMARY_PROJECT_FUNDINGS
Line 1683: FROM pa_summary_project_fundings a,
1679: CURSOR get_proj_backlog IS
1680: SELECT DISTINCT pa.project_id project_id
1681: FROM (SELECT a.project_id ,
1682: SUM (a.total_accrued_amount) total_rev 1683: FROM pa_summary_project_fundings a, 1684: pa_projects_all ppa
1685: where PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(ppa.project_status_code,'STATUS_REPORTING') = 'Y'
1686: and a.project_id = ppa.project_id
1687: GROUP BY a.project_id