DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on AMS_USER_STATUSES_VL

Line 11361: FROM ams_user_statuses_vl

11357: WHERE qp_list_header_id = l_qp_list_header_id;
11358:
11359: CURSOR c_user_status_id(l_new_status VARCHAR2) IS
11360: SELECT min(user_status_id)
11361: FROM ams_user_statuses_vl
11362: WHERE system_status_type = 'OZF_OFFR_STATUS'
11363: AND system_status_code=l_new_status;
11364:
11365: CURSOR c_sdr_info(l_sdr_hdr_id NUMBER) IS