DBA Data[Home] [Help]

APPS.AP_WEB_DB_HR_INT_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 406: FROM hr_employees_current_v h,

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