DBA Data[Home] [Help]

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