DBA Data[Home] [Help]

APPS.AP_WEB_DB_CCARD_PKG dependencies on PER_CONT_WORKERS_CURRENT_X

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: