160: AND ROWNUM < 3;
161:
162: CURSOR l_invalid_site_cur IS
163: SELECT akw.number_value
164: FROM ak_web_user_sec_attr_values akw, ap_supplier_sites_all pvs
165: WHERE akw.web_user_id = p_user_id
166: AND akw.attribute_code = 'ICX_SUPPLIER_SITE_ID'
167: AND akw.attribute_application_id = 177
168: AND akw.number_value = pvs.vendor_site_id
181: AND akw.attribute_application_id = 177
182: AND akw.number_value = pvc.vendor_contact_id
183: AND pvc.vendor_site_id not in
184: (SELECT vendor_site_id
185: FROM ap_supplier_sites_all
186: WHERE vendor_id in
187: (select vendor_id
188: from ap_suppliers
189: start with vendor_id = l_root_vendor_id