APPS.AP_WEB_AUDIT_UTILS dependencies on AP_WEB_DB_HR_INT_PKG

Line 84: 'WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)=''Y'' ' ||

80: l_query_stmt := 'select ' || p_column || ' ' ||
81: 'from ' ||
82: '(SELECT ' || l_column1 || ' ' || p_column || ' ' ||
83: 'FROM PER_EMPLOYEES_X EMP ' ||
84: 'WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)=''Y'' ' ||
85: 'AND EMP.EMPLOYEE_ID = :b1 ' ||
86: 'UNION ALL ' ||
87: 'SELECT ' || l_column2 || ' ' || p_column || ' ' ||
88: 'FROM PER_CONT_WORKERS_CURRENT_X CWK ' ||

Line 1289: WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)='Y'

1285: FROM
1286: (SELECT EMP.ORGANIZATION_ID ORGANIZATION_ID,
1287: EMP.EMPLOYEE_ID PERSON_ID
1288: FROM PER_EMPLOYEES_X EMP
1289: WHERE NOT AP_WEB_DB_HR_INT_PKG.ISPERSONCWK(EMP.EMPLOYEE_ID)='Y'
1290: AND EMP.EMPLOYEE_ID = p_person_id
1291: UNION ALL
1292: SELECT CWK.ORGANIZATION_ID ORGANIZATION_ID,
1293: CWK.PERSON_ID

Line 1998: RETURN AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_employee_id);

1994: p_org_id IN NUMBER) RETURN VARCHAR2 IS
1995:
1996: BEGIN
1997:
1998: RETURN AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_employee_id);
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: /* Even when exception is thrown we do not want to propagate it upwards