APPS.OZF_SD_REQUEST_PUB dependencies on AMS_LIST_HEADERS_ALL

Line 2308: FROM ams_list_headers_all

2304: AND party_id = p_party_id;
2305:
2306: CURSOR c_get_list_header(p_list_header_id IN VARCHAR2)IS
2307: SELECT 1
2308: FROM ams_list_headers_all
2309: WHERE status_code IN ( 'AVAILABLE','LOCKED','EXECUTED','EXECUTING','VALIDATED','VALIDATING')
2310: AND list_header_id = p_list_header_id;
2311:
2312: CURSOR c_get_segment(p_cell_id IN VARCHAR2)IS