APPS.AP_ISP_UTILITIES_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 2146: FROM ak_web_user_sec_attr_values awusav

2142: -- we are assuming the attr_code is ICX_SUPPLIER_ORG_ID
2143: -- still pass it to allow reusability
2144: SELECT count(1) attr_value_num
2145: INTO l_sec_attr_cnt
2146: FROM ak_web_user_sec_attr_values awusav
2147: WHERE awusav.web_user_id = p_user_id
2148: AND awusav.attribute_code = p_attr_code
2149: AND awusav.attribute_application_id = 177;
2150:

Line 2159: FROM ak_web_user_sec_attr_values asav

2155:
2156: IF ( l_sec_attr_cnt = 1 ) THEN
2157: SELECT nvl(to_char(asav.number_value), nvl(asav.varchar2_value, to_char(asav.date_value)))
2158: INTO p_attr_value
2159: FROM ak_web_user_sec_attr_values asav
2160: WHERE asav.attribute_application_id = 177
2161: AND asav.web_user_id = p_user_id
2162: AND asav.attribute_code = p_attr_code;
2163: END IF;