APPS.POS_SEARCH_DUP_PARTY_PKG dependencies on POS_CONTACT_REQUESTS

Line 51: FROM pos_contact_requests

47:
48: CURSOR c_supp_contact_cur IS
49: SELECT (first_name || ' ' || last_name) contact_name,
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);