APPS.AP_WEB_DB_CCARD_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

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'

Line 1745: FROM per_cont_workers_current_x h, ak_web_user_sec_attr_values a

1741: AND h.employee_id = a.number_value
1742: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='Y'
1743: UNION ALL
1744: SELECT h.person_id employee_id
1745: FROM per_cont_workers_current_x h, ak_web_user_sec_attr_values a
1746: WHERE a.attribute_code = 'ICX_HR_PERSON_ID'
1747: AND a.web_user_id = p_user_id
1748: AND h.person_id = a.number_value;
1749: