APPS.AP_WEB_DB_CCARD_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 1509: if (AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND

1505: p_resp_id => null,
1506: p_apps_id => null);
1507:
1508: IF (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employee_id, l_has)) THEN
1509: if (AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND
1510: l_has = 'Y' AND l_cCardEnabled = 'Y') THEN
1511: return 'Y';
1512: end if;
1513: END IF;

Line 1742: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='Y'

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'
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'