DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_STATUSES

Line 994: ,pa_project_statuses ps

990: ,proj.project_type -- Added for bug#5098966
991: ,proj.start_date
992: ,proj.completion_date
993: from pa_projects_all proj
994: ,pa_project_statuses ps
995: ,pa_project_types type
996: where proj.project_status_code = ps.project_status_code
997: and proj.project_type = type.project_type
998: and proj.project_id = p_project_id

Line 1189: ,pa_project_statuses ps

1185: CURSOR c_prj IS
1186: select ps.project_system_status_code
1187: ,type.project_type_class_code
1188: from pa_projects_all proj
1189: ,pa_project_statuses ps
1190: ,pa_project_types type
1191: where proj.project_status_code = ps.project_status_code
1192: and proj.project_type=type.project_type
1193: and proj.project_id = p_project_id