APPS.AP_WEB_DB_CCARD_PKG dependencies on PER_EMPLOYEES_X

Line 1738: FROM per_employees_x h, ak_web_user_sec_attr_values a

1734: l_num_credits NUMBER := 0;
1735:
1736: CURSOR delegates IS
1737: SELECT h.employee_id
1738: FROM per_employees_x h, ak_web_user_sec_attr_values a
1739: WHERE a.attribute_code = 'ICX_HR_PERSON_ID'
1740: AND a.web_user_id = p_user_id
1741: AND h.employee_id = a.number_value
1742: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='Y'