DBA Data[Home] [Help]

APPS.AMS_IMPORT_LIST_PVT dependencies on AMS_USER_STATUSES_B

Line 596: FROM ams_user_statuses_b

592: -- SOLIN, SQL repository
593: CURSOR c_get_status_id(c_status_type VARCHAR2, c_status_code VARCHAR2,
594: c_flag VARCHAR2) IS
595: SELECT user_status_id
596: FROM ams_user_statuses_b
597: WHERE system_status_type = c_status_type -- 'AMS_IMPORT_STATUS'
598: AND system_status_code = c_status_code -- 'NEW'
599: AND default_flag = c_flag; -- 'Y';
600:

Line 792: FROM ams_user_statuses_b

788: -- SOLIN, SQL repository
789: CURSOR c_get_status_id(c_status_type VARCHAR2, c_status_code VARCHAR2,
790: c_flag VARCHAR2) IS
791: SELECT user_status_id
792: FROM ams_user_statuses_b
793: WHERE system_status_type = c_status_type -- 'AMS_IMPORT_STATUS'
794: AND system_status_code = c_status_code -- 'NEW'
795: AND default_flag = c_flag; -- 'Y';
796: