APPS.POS_VENDOR_UTIL_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 145: FROM ak_web_user_sec_attr_values akw, ap_suppliers pv

141: l_number NUMBER;
142:
143: CURSOR l_vendor_cur IS
144: SELECT akw.number_value
145: FROM ak_web_user_sec_attr_values akw, ap_suppliers pv
146: WHERE akw.web_user_id = p_user_id
147: AND akw.attribute_code = 'ICX_SUPPLIER_ORG_ID'
148: AND akw.attribute_application_id = 177
149: AND akw.number_value = pv.vendor_id

Line 153: FROM ak_web_user_sec_attr_values

149: AND akw.number_value = pv.vendor_id
150: AND ((pv.parent_vendor_id is null) OR
151: (pv.parent_vendor_id not in
152: (SELECT number_value
153: FROM ak_web_user_sec_attr_values
154: WHERE web_user_id = p_user_id
155: AND attribute_code = 'ICX_SUPPLIER_ORG_ID'
156: AND attribute_application_id = 177
157: )

Line 164: FROM ak_web_user_sec_attr_values akw, ap_supplier_sites_all pvs

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

Line 178: FROM ak_web_user_sec_attr_values akw, po_vendor_contacts pvc

174: AND ROWNUM < 2;
175:
176: CURSOR l_invalid_contact_cur IS
177: SELECT akw.number_value
178: FROM ak_web_user_sec_attr_values akw, po_vendor_contacts pvc
179: WHERE akw.web_user_id = p_user_id
180: AND akw.attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
181: AND akw.attribute_application_id = 177
182: AND akw.number_value = pvc.vendor_contact_id