APPS.OZF_PRICELIST_PVT dependencies on AMS_USER_STATUSES_VL

Line 202: FROM ams_user_statuses_vl

198: WHERE list_header_id = p_list_header_id;
199:
200: CURSOR cur_get_system_status_code(p_user_status_id NUMBER) IS
201: SELECT system_status_code
202: FROM ams_user_statuses_vl
203: WHERE user_status_id = p_user_status_id;
204:
205: CURSOR cur_get_user_status_id(l_status_code VARCHAR2) IS
206: SELECT user_status_id

Line 207: FROM ams_user_statuses_vl

203: WHERE user_status_id = p_user_status_id;
204:
205: CURSOR cur_get_user_status_id(l_status_code VARCHAR2) IS
206: SELECT user_status_id
207: FROM ams_user_statuses_vl
208: WHERE system_status_type = 'OZF_PRICELIST_STATUS'
209: AND system_status_code = l_status_code
210: AND TRUNC(sysdate) BETWEEN NVL(start_date_active, TRUNC(SYSDATE)) and NVL(end_date_active, TRUNC(sysdate))
211: AND default_flag = 'Y'