APPS.PSP_ENC_PRE_PROCESS dependencies on PA_PROJECT_STATUS_CONTROLS

Line 1278: /* Cursor to validate enabled_flag from pa_project_status_controls */

1274: NVL(poe.date_to, TO_DATE('4712/12/31', 'YYYY/MM/DD'))
1275: FROM pa_organizations_expend_v poe
1276: WHERE poe.organization_id = p_expenditure_organization_id;
1277:
1278: /* Cursor to validate enabled_flag from pa_project_status_controls */
1279: CURSOR project_status_csr IS
1280: SELECT ppsc.enabled_flag
1281: FROM pa_project_status_controls ppsc
1282: WHERE ppsc.project_status_code = l_proj_status_code

Line 1281: FROM pa_project_status_controls ppsc

1277:
1278: /* Cursor to validate enabled_flag from pa_project_status_controls */
1279: CURSOR project_status_csr IS
1280: SELECT ppsc.enabled_flag
1281: FROM pa_project_status_controls ppsc
1282: WHERE ppsc.project_status_code = l_proj_status_code
1283: AND ppsc.action_code = 'NEW_TXNS';
1284:
1285: -- Introduced for bug fix 3434626