APPS.AME_SUPERVISORY_HANDLER dependencies on PER_ALL_ASSIGNMENTS_F

Line 39: per_all_assignments_f

35: begin
36: select supervisor_id
37: into supervisorPersonId
38: from
39: per_all_assignments_f
40: where
41: person_id = personIdIn and
42: per_all_assignments_f.primary_flag = 'Y' and
43: per_all_assignments_f.assignment_type in ('E','C') and

Line 42: per_all_assignments_f.primary_flag = 'Y' and

38: from
39: per_all_assignments_f
40: where
41: person_id = personIdIn and
42: per_all_assignments_f.primary_flag = 'Y' and
43: per_all_assignments_f.assignment_type in ('E','C') and
44: per_all_assignments_f.assignment_status_type_id not in
45: (select assignment_status_type_id
46: from per_assignment_status_types

Line 43: per_all_assignments_f.assignment_type in ('E','C') and

39: per_all_assignments_f
40: where
41: person_id = personIdIn and
42: per_all_assignments_f.primary_flag = 'Y' and
43: per_all_assignments_f.assignment_type in ('E','C') and
44: per_all_assignments_f.assignment_status_type_id not in
45: (select assignment_status_type_id
46: from per_assignment_status_types
47: where per_system_status = 'TERM_ASSIGN') and

Line 44: per_all_assignments_f.assignment_status_type_id not in

40: where
41: person_id = personIdIn and
42: per_all_assignments_f.primary_flag = 'Y' and
43: per_all_assignments_f.assignment_type in ('E','C') and
44: per_all_assignments_f.assignment_status_type_id not in
45: (select assignment_status_type_id
46: from per_assignment_status_types
47: where per_system_status = 'TERM_ASSIGN') and
48: trunc(sysdate) between

Line 49: per_all_assignments_f.effective_start_date and

45: (select assignment_status_type_id
46: from per_assignment_status_types
47: where per_system_status = 'TERM_ASSIGN') and
48: trunc(sysdate) between
49: per_all_assignments_f.effective_start_date and
50: per_all_assignments_f.effective_end_date;
51: if(supervisorPersonId is null) then
52: raise nullIdException;
53: end if;

Line 50: per_all_assignments_f.effective_end_date;

46: from per_assignment_status_types
47: where per_system_status = 'TERM_ASSIGN') and
48: trunc(sysdate) between
49: per_all_assignments_f.effective_start_date and
50: per_all_assignments_f.effective_end_date;
51: if(supervisorPersonId is null) then
52: raise nullIdException;
53: end if;
54: return(supervisorPersonId);