APPS.POS_SEARCH_DUP_PARTY_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 45: from pos_supplier_mappings

41: CURSOR c_supp_addr_cur IS
42: SELECT address_line1, city, state, postal_code, country
43: FROM POS_ADDRESS_REQUESTS
44: WHERE mapping_id = (select mapping_id
45: from pos_supplier_mappings
46: where supplier_reg_id = p_sup_reg_id);
47:
48: CURSOR c_supp_contact_cur IS
49: SELECT (first_name || ' ' || last_name) contact_name,

Line 54: from pos_supplier_mappings

50: email_address, phone_number
51: FROM pos_contact_requests
52: WHERE do_not_delete = 'Y' and
53: mapping_id = (select mapping_id
54: from pos_supplier_mappings
55: where supplier_reg_id = p_sup_reg_id);
56:
57:
58: BEGIN