APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_IMP_DOCUMENTS

Line 3313: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;

3309: and import_source_line_id = p_import_source_line_id
3310: and batch_id = l_batch_id;
3311:
3312: cursor c_file_type is
3313: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
3314:
3315: cursor c_b2b is
3316: select org_imp_xml_element_id, add_imp_xml_element_id, ocont_imp_xml_element_id, cp_imp_xml_element_id,
3317: em_imp_xml_element_id from ams_hz_b2b_mapping_v where import_list_header_id = p_import_list_header_id