APPS.AR_AME_CMWF_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 217: FROM per_all_assignments_f

213: l_manager_employee_id NUMBER;
214:
215: CURSOR mgr IS
216: SELECT supervisor_id
217: FROM per_all_assignments_f
218: WHERE person_id = l_employee_id
219: AND per_all_assignments_f.primary_flag = 'Y'
220: AND per_all_assignments_f.assignment_type in ('E','C')
221: AND per_all_assignments_f.assignment_status_type_id

Line 219: AND per_all_assignments_f.primary_flag = 'Y'

215: CURSOR mgr IS
216: SELECT supervisor_id
217: FROM per_all_assignments_f
218: WHERE person_id = l_employee_id
219: AND per_all_assignments_f.primary_flag = 'Y'
220: AND per_all_assignments_f.assignment_type in ('E','C')
221: AND per_all_assignments_f.assignment_status_type_id
222: NOT IN
223: (SELECT assignment_status_type_id

Line 220: AND per_all_assignments_f.assignment_type in ('E','C')

216: SELECT supervisor_id
217: FROM per_all_assignments_f
218: WHERE person_id = l_employee_id
219: AND per_all_assignments_f.primary_flag = 'Y'
220: AND per_all_assignments_f.assignment_type in ('E','C')
221: AND per_all_assignments_f.assignment_status_type_id
222: NOT IN
223: (SELECT assignment_status_type_id
224: FROM per_assignment_status_types

Line 221: AND per_all_assignments_f.assignment_status_type_id

217: FROM per_all_assignments_f
218: WHERE person_id = l_employee_id
219: AND per_all_assignments_f.primary_flag = 'Y'
220: AND per_all_assignments_f.assignment_type in ('E','C')
221: AND per_all_assignments_f.assignment_status_type_id
222: NOT IN
223: (SELECT assignment_status_type_id
224: FROM per_assignment_status_types
225: WHERE per_system_status = 'TERM_ASSIGN');

Line 2777: FROM per_all_assignments_f

2773:
2774:
2775: CURSOR manager (p_employee_id NUMBER) IS
2776: SELECT supervisor_id
2777: FROM per_all_assignments_f
2778: WHERE person_id = p_employee_id
2779: AND primary_flag = 'Y' -- get primary assgt
2780: AND assignment_type = 'E' -- ensure emp assgt, not applicant assgt
2781: AND trunc(sysdate) BETWEEN effective_start_date