APPS.AP_WEB_DB_HR_INT_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 43: ak_web_user_sec_attr_values a

39: BEGIN
40: OPEN p_emp_name_cursor FOR
41: SELECT h.employee_id, h.full_name ||' ('||h.employee_num||') ' nameNum
42: FROM per_employees_x h,
43: ak_web_user_sec_attr_values a
44: WHERE a.attribute_code = 'ICX_HR_PERSON_ID'
45: AND a.web_user_id = p_web_user_id
46: AND h.employee_id = a.number_value
47: ORDER BY UPPER(h.full_name);

Line 74: ak_web_user_sec_attr_values a

70: BEGIN
71: OPEN p_emp_name_cursor FOR
72: SELECT h.employee_id, h.full_name ||' ('||h.employee_num||') ' nameNum
73: FROM per_employees_current_x h,
74: ak_web_user_sec_attr_values a
75: WHERE a.attribute_code = 'ICX_HR_PERSON_ID'
76: AND a.web_user_id = p_web_user_id
77: AND h.employee_id = a.number_value
78: ORDER BY UPPER(h.full_name);

Line 189: ak_web_user_sec_attr_values a

185: -- return one row per person_id. PER_WORKFORCE_X could return 2 rows.
186: SELECT count(*)
187: INTO p_count
188: FROM per_people_x h,
189: ak_web_user_sec_attr_values a
190: WHERE a.attribute_code = p_attribute_code
191: AND a.web_user_id = p_web_user_id
192: AND h.person_id = a.number_value;
193:

Line 406: ak_web_user_sec_attr_values a

402: BEGIN
403: SELECT COUNT(*)
404: INTO l_security_attr_cnt
405: FROM hr_employees_current_v h,
406: ak_web_user_sec_attr_values a
407: WHERE a.attribute_code = 'ICX_HR_PERSON_ID'
408: AND a.web_user_id = P_WebUserID
409: AND h.employee_id = a.number_value;
410: