APPS.PA_CLIENT_EXTN_PROJECT_WF dependencies on PA_PROJECTS_ALL

Line 249: FROM pa_projects_all

245: WHERE object_type = 'PA_PROJECTS'
246: AND object_id = l_project_id
247: AND new_project_status_code =
248: (SELECT project_status_code
249: FROM pa_projects_all
250: WHERE project_id = l_project_id)
251: ORDER BY obj_status_change_id DESC
252: )
253: WHERE rownum = 1;