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:
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: