DBA Data[Home] [Help]

APPS.AMS_IMPORT_LIST_PVT dependencies on AMS_USER_STATUSES_B

Line 603: FROM ams_user_statuses_b

599: -- SOLIN, SQL repository
600: CURSOR c_get_status_id(c_status_type VARCHAR2, c_status_code VARCHAR2,
601: c_flag VARCHAR2) IS
602: SELECT user_status_id
603: FROM ams_user_statuses_b
604: WHERE system_status_type = c_status_type -- 'AMS_IMPORT_STATUS'
605: AND system_status_code = c_status_code -- 'NEW'
606: AND default_flag = c_flag; -- 'Y';
607:

Line 799: FROM ams_user_statuses_b

795: -- SOLIN, SQL repository
796: CURSOR c_get_status_id(c_status_type VARCHAR2, c_status_code VARCHAR2,
797: c_flag VARCHAR2) IS
798: SELECT user_status_id
799: FROM ams_user_statuses_b
800: WHERE system_status_type = c_status_type -- 'AMS_IMPORT_STATUS'
801: AND system_status_code = c_status_code -- 'NEW'
802: AND default_flag = c_flag; -- 'Y';
803: