APPS.OZF_OFFER_PVT dependencies on AMS_USER_STATUSES_VL

Line 12169: FROM ams_user_statuses_vl

12165: WHERE qp_list_header_id = l_qp_list_header_id;
12166:
12167: CURSOR c_user_status_id(l_new_status VARCHAR2) IS
12168: SELECT min(user_status_id)
12169: FROM ams_user_statuses_vl
12170: WHERE system_status_type = 'OZF_OFFR_STATUS'
12171: AND system_status_code=l_new_status;
12172:
12173: CURSOR c_sdr_info(l_sdr_hdr_id NUMBER) IS