APPS.AP_ISP_UTILITIES_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 1854: FROM ak_web_user_sec_attr_values awusav

1850: -- we are assuming the attr_code is ICX_SUPPLIER_ORG_ID
1851: -- still pass it to allow reusability
1852: SELECT count(1) attr_value_num
1853: INTO l_sec_attr_cnt
1854: FROM ak_web_user_sec_attr_values awusav
1855: WHERE awusav.web_user_id = p_user_id
1856: AND awusav.attribute_code = p_attr_code
1857: AND awusav.attribute_application_id = 177;
1858:

Line 1867: FROM ak_web_user_sec_attr_values asav

1863:
1864: IF ( l_sec_attr_cnt = 1 ) THEN
1865: SELECT nvl(to_char(asav.number_value), nvl(asav.varchar2_value, to_char(asav.date_value)))
1866: INTO p_attr_value
1867: FROM ak_web_user_sec_attr_values asav
1868: WHERE asav.attribute_application_id = 177
1869: AND asav.web_user_id = p_user_id
1870: AND asav.attribute_code = p_attr_code;
1871: END IF;