DBA Data[Home] [Help]

APPS.AP_WEB_DB_HR_INT_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 405: FROM hr_employees_current_v h,

401: l_security_attr_cnt NUMBER := 0;
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;