APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_HZ_B2B_MAPPING_V

Line 360: select ORG_IMP_XML_ELEMENT_ID from ams_hz_b2b_mapping_v

356: where import_list_header_id = p_import_list_header_id;
357:
358:
359: cursor b2bxml is
360: select ORG_IMP_XML_ELEMENT_ID from ams_hz_b2b_mapping_v
361: where import_source_line_id = i_import_source_line_id;
362:
363: cursor b2cxml is
364: select PER_IMP_XML_ELEMENT_ID from ams_hz_b2c_mapping_v

Line 576: from ams_hz_b2b_mapping_v

572: AND email_address = x_email_address;
573:
574: cursor c_b2b_source_rec is
575: select ORG_PARTY_ID,OCONT_PARTY_ID,PARTY_LOCATION_ID,ORG_KEY,org_location_id
576: from ams_hz_b2b_mapping_v
577: where import_source_line_id = i_import_source_line_id;
578:
579: cursor c_b2c_source_rec is
580: select person_PARTY_ID,PARTY_LOCATION_ID

Line 3317: em_imp_xml_element_id from ams_hz_b2b_mapping_v where import_list_header_id = p_import_list_header_id

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
3318: and import_source_line_id = p_import_source_line_id;
3319:
3320:
3321: cursor c_b2c is