DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJ_STATUS dependencies on PA_PROJECT_STATUSES

Line 76: from pa_project_statuses

72: as follows:
73: IF X_new_proj_status_code IS NOT NULL THEN
74: select project_system_status_code
75: into l_system_status_code
76: from pa_project_statuses
77: where project_status_code = X_new_proj_status_code;
78: END IF;
79: IF (l_system_status_code = 'APPROVED', THEN
80: Note that you can specify tokens for the messages while

Line 296: FROM pa_project_statuses

292:
293:
294: CURSOR l_sel_proj_stus_csr IS
295: select NVL(enable_wf_flag,'N')
296: FROM pa_project_statuses
297: WHERE project_status_code = x_project_status_code;
298:
299: l_wf_enabled_flag VARCHAR2(1) := 'N';
300: l_org_id NUMBER;