APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_IMP_DOCUMENTS

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

3302: and import_source_line_id = p_import_source_line_id
3303: and batch_id = l_batch_id;
3304:
3305: cursor c_file_type is
3306: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
3307:
3308: cursor c_b2b is
3309: select org_imp_xml_element_id, add_imp_xml_element_id, ocont_imp_xml_element_id, cp_imp_xml_element_id,
3310: em_imp_xml_element_id from ams_hz_b2b_mapping_v where import_list_header_id = p_import_list_header_id