APPS.PA_REV_CA dependencies on PA_PROJECT_STATUSES

Line 1190: FROM pa_projects_all ppa , pa_project_statuses pps

1186: -- Select the project system status code
1187:
1188: SELECT pps.project_system_status_code
1189: INTO l_project_status
1190: FROM pa_projects_all ppa , pa_project_statuses pps
1191: WHERE ppa.project_id = x_project_id
1192: AND ppa.project_status_code = pps.project_status_code
1193: AND pps.status_type = 'PROJECT';
1194:

Line 1659: from pa_project_statuses

1655: -- If system status is CLOSED then perform the checks
1656: --
1657: select project_system_status_code
1658: into l_new_system_status_code
1659: from pa_project_statuses
1660: where project_status_code = x_new_proj_status_code
1661: and status_type = 'PROJECT';
1662:
1663: select project_system_status_code

Line 1665: from pa_project_statuses

1661: and status_type = 'PROJECT';
1662:
1663: select project_system_status_code
1664: into l_old_system_status_code
1665: from pa_project_statuses
1666: where project_status_code = x_old_proj_status_code
1667: and status_type = 'PROJECT';
1668:
1669: -- IF l_new_system_status_code = 'CLOSED' THEN