DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_STATUSES

Line 997: ,pa_project_statuses ps

993: ,proj.project_type -- Added for bug#5098966
994: ,trunc(proj.start_date)
995: ,trunc(proj.completion_date)
996: from pa_projects_all proj
997: ,pa_project_statuses ps
998: ,pa_project_types type
999: where proj.project_status_code = ps.project_status_code
1000: and proj.project_type = type.project_type
1001: and proj.project_id = p_project_id

Line 1203: ,pa_project_statuses ps

1199: CURSOR c_prj IS
1200: select ps.project_system_status_code
1201: ,type.project_type_class_code
1202: from pa_projects_all proj
1203: ,pa_project_statuses ps
1204: ,pa_project_types type
1205: where proj.project_status_code = ps.project_status_code
1206: and proj.project_type=type.project_type
1207: and proj.project_id = p_project_id