APPS.POS_PROFILE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 934: select vendor_site_id, party_site_id, vendor_id from ap_supplier_sites_all where party_site_id = p_party_site_id;

930: l_obj_ver HZ_PARTY_SITES.object_version_number%TYPE;
931: l_created_by_module HZ_PARTY_SITES.created_by_module%TYPE;
932:
933: cursor l_site_cur is
934: select vendor_site_id, party_site_id, vendor_id from ap_supplier_sites_all where party_site_id = p_party_site_id;
935: l_site_rec l_site_cur%ROWTYPE;
936: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
937: l_return_status varchar2(1);
938: l_msg_data varchar2(4000);