APPS.AMS_ACTRESOURCE_PVT dependencies on AMS_USER_STATUSES_V

Line 90: SELECT system_status_code FROM ams_user_statuses_v

86: WHERE agenda_id = id_in
87: AND agenda_type = type_in;
88:
89: CURSOR c_get_sys_stat_code(id_in IN NUMBER) is
90: SELECT system_status_code FROM ams_user_statuses_v
91: WHERE user_status_id = id_in;
92:
93: BEGIN
94: -- Standard Start of API savepoint

Line 353: SELECT system_status_code FROM ams_user_statuses_v

349: WHERE agenda_id = id_in
350: AND agenda_type = type_in;
351:
352: CURSOR c_get_sys_stat_code(id_in IN NUMBER) is
353: SELECT system_status_code FROM ams_user_statuses_v
354: WHERE user_status_id = id_in;
355:
356: BEGIN
357: -- Standard Start of API savepoint