DBA Data[Home] [Help]

APPS.AP_WEB_DB_HR_INT_PKG dependencies on PER_EMPLOYEES_CURRENT_X

Line 73: FROM per_employees_current_x h,

69: --------------------------------------------------------------------------------
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