DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_WEB_DB_HR_INT_PKG

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

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