APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_HZ_B2C_MAPPING_V

Line 364: select PER_IMP_XML_ELEMENT_ID from ams_hz_b2c_mapping_v

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
365: where import_source_line_id = i_import_source_line_id;
366:
367: CURSOR PARTY_REL_EXISTS IS
368: SELECT party_id, relationship_id FROM hz_relationships

Line 581: from ams_hz_b2c_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
581: from ams_hz_b2c_mapping_v
582: where import_source_line_id = i_import_source_line_id;
583:
584: cursor c_org_party is
585: select party_id from hz_parties

Line 3323: from ams_hz_b2c_mapping_v where import_list_header_id = p_import_list_header_id

3319:
3320:
3321: cursor c_b2c is
3322: select per_imp_xml_element_id, add_imp_xml_element_id, cp_imp_xml_element_id, em_imp_xml_element_id
3323: from ams_hz_b2c_mapping_v where import_list_header_id = p_import_list_header_id
3324: and import_source_line_id = p_import_source_line_id;
3325:
3326:
3327: begin