DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 1275: FROM pa_organizations_expend_v poe

1271: /* Cursor is used to fetch exp org date and to validate exp org */
1272: CURSOR exp_org_cur IS
1273: SELECT NVL(poe.date_from, TO_DATE('1800/01/01', 'YYYY/MM/DD')),
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