APPS.AME_ABSOLUTE_JOB_LEVEL_HANDLER dependencies on PER_ALL_ASSIGNMENTS_F

Line 43: per_all_assignments_f.supervisor_id

39: personDisplayName ame_util.longStringType;
40: begin
41: select
42: nvl(per_jobs.approval_authority, 0),
43: per_all_assignments_f.supervisor_id
44: into
45: jobLevelOut,
46: supervisorIdOut
47: from

Line 49: per_all_assignments_f

45: jobLevelOut,
46: supervisorIdOut
47: from
48: per_jobs,
49: per_all_assignments_f
50: where
51: per_jobs.job_id = per_all_assignments_f.job_id and
52: per_all_assignments_f.person_id = personIdIn and
53: per_all_assignments_f.primary_flag = 'Y' and

Line 51: per_jobs.job_id = per_all_assignments_f.job_id and

47: from
48: per_jobs,
49: per_all_assignments_f
50: where
51: per_jobs.job_id = per_all_assignments_f.job_id and
52: per_all_assignments_f.person_id = personIdIn and
53: per_all_assignments_f.primary_flag = 'Y' and
54: per_all_assignments_f.assignment_type in ('E','C') and
55: per_all_assignments_f.assignment_status_type_id not in

Line 52: per_all_assignments_f.person_id = personIdIn and

48: per_jobs,
49: per_all_assignments_f
50: where
51: per_jobs.job_id = per_all_assignments_f.job_id and
52: per_all_assignments_f.person_id = personIdIn and
53: per_all_assignments_f.primary_flag = 'Y' and
54: per_all_assignments_f.assignment_type in ('E','C') and
55: per_all_assignments_f.assignment_status_type_id not in
56: (select assignment_status_type_id

Line 53: per_all_assignments_f.primary_flag = 'Y' and

49: per_all_assignments_f
50: where
51: per_jobs.job_id = per_all_assignments_f.job_id and
52: per_all_assignments_f.person_id = personIdIn and
53: per_all_assignments_f.primary_flag = 'Y' and
54: per_all_assignments_f.assignment_type in ('E','C') and
55: per_all_assignments_f.assignment_status_type_id not in
56: (select assignment_status_type_id
57: from per_assignment_status_types

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

50: where
51: per_jobs.job_id = per_all_assignments_f.job_id and
52: per_all_assignments_f.person_id = personIdIn and
53: per_all_assignments_f.primary_flag = 'Y' and
54: per_all_assignments_f.assignment_type in ('E','C') and
55: per_all_assignments_f.assignment_status_type_id not in
56: (select assignment_status_type_id
57: from per_assignment_status_types
58: where per_system_status = 'TERM_ASSIGN') and

Line 55: per_all_assignments_f.assignment_status_type_id not in

51: per_jobs.job_id = per_all_assignments_f.job_id and
52: per_all_assignments_f.person_id = personIdIn and
53: per_all_assignments_f.primary_flag = 'Y' and
54: per_all_assignments_f.assignment_type in ('E','C') and
55: per_all_assignments_f.assignment_status_type_id not in
56: (select assignment_status_type_id
57: from per_assignment_status_types
58: where per_system_status = 'TERM_ASSIGN') and
59: trunc(sysdate) between

Line 60: per_all_assignments_f.effective_start_date and

56: (select assignment_status_type_id
57: from per_assignment_status_types
58: where per_system_status = 'TERM_ASSIGN') and
59: trunc(sysdate) between
60: per_all_assignments_f.effective_start_date and
61: per_all_assignments_f.effective_end_date;
62: if(jobLevelOut is null) then
63: raise jobLevelException;
64: end if;

Line 61: per_all_assignments_f.effective_end_date;

57: from per_assignment_status_types
58: where per_system_status = 'TERM_ASSIGN') and
59: trunc(sysdate) between
60: per_all_assignments_f.effective_start_date and
61: per_all_assignments_f.effective_end_date;
62: if(jobLevelOut is null) then
63: raise jobLevelException;
64: end if;
65: exception