DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on AMS_USER_STATUSES_B

Line 1833: FROM AMS_USER_STATUSES_B

1829:
1830:
1831: CURSOR c_get_status_code(cv_status_code VARCHAR2) IS
1832: SELECT user_status_id
1833: FROM AMS_USER_STATUSES_B
1834: where SYSTEM_STATUS_TYPE='PV_PROGRAM_STATUS'
1835: and SYSTEM_STATUS_CODE=cv_status_code;
1836:
1837: CURSOR c_get_objverno(cv_program_id NUMBER) IS