APPS.PO_VENDORS_PVT dependencies on FND_USER_RESP_GROUPS

Line 142: fnd_user_resp_groups fur

138: cursor vendor_only_username(v_vendor_id NUMBER) IS
139: select DISTINCT user1.user_name
140: from fnd_user user1,
141: ak_web_user_sec_attr_values ak1,
142: fnd_user_resp_groups fur
143: where ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
144: and ak1.number_value=v_vendor_id
145: and ak1.ATTRIBUTE_APPLICATION_ID=177
146: and ak1.web_user_id=user1.user_id

Line 175: fnd_user_resp_groups fur

171: select DISTINCT user1.user_name
172: from fnd_user user1,
173: ak_web_user_sec_attr_values ak1,
174: ak_web_user_sec_attr_values ak2,
175: fnd_user_resp_groups fur
176: where
177: user1.user_id=ak1.web_user_id
178: and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
179: and ak1.number_value=v_vendor_id

Line 209: fnd_user_resp_groups fur

205: select DISTINCT user1.user_name
206: from fnd_user user1,
207: ak_web_user_sec_attr_values ak1,
208: ak_web_user_sec_attr_values ak3,
209: fnd_user_resp_groups fur
210: where user1.user_id=ak1.web_user_id
211: and ak1.attribute_code='ICX_SUPPLIER_ORG_ID'
212: and ak1.number_value=v_vendor_id
213: and ak1.ATTRIBUTE_APPLICATION_ID=177