DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_WEB_DB_HR_INT_PKG

Line 47: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(P.employee_id)='Y'

43: FROM per_all_assignments_f ass,
44: per_employees_x P
45: WHERE P.EMPLOYEE_ID = p_person_id
46: AND ass.assignment_id = P.assignment_id
47: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(P.employee_id)='Y'
48: AND p_date >= effective_start_date and p_date <= effective_end_date
49: AND ass.assignment_type = 'E'
50: UNION ALL
51: SELECT p_person_id, effective_start_date, effective_end_date, grade_id, job_id, position_id