APPS.PER_TMPROFILE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 15: from per_all_assignments_f

11: loop
12: begin
13: select supervisor_id
14: into l_supervisor_id
15: from per_all_assignments_f
16: where per_all_assignments_f.person_id = l_current_person_id
17: and per_all_assignments_f.primary_flag = 'Y'
18: and per_all_assignments_f.assignment_type in ('E','C')
19: and per_all_assignments_f.assignment_status_type_id not in

Line 16: where per_all_assignments_f.person_id = l_current_person_id

12: begin
13: select supervisor_id
14: into l_supervisor_id
15: from per_all_assignments_f
16: where per_all_assignments_f.person_id = l_current_person_id
17: and per_all_assignments_f.primary_flag = 'Y'
18: and per_all_assignments_f.assignment_type in ('E','C')
19: and per_all_assignments_f.assignment_status_type_id not in
20: (select assignment_status_type_id

Line 17: and per_all_assignments_f.primary_flag = 'Y'

13: select supervisor_id
14: into l_supervisor_id
15: from per_all_assignments_f
16: where per_all_assignments_f.person_id = l_current_person_id
17: and per_all_assignments_f.primary_flag = 'Y'
18: and per_all_assignments_f.assignment_type in ('E','C')
19: and per_all_assignments_f.assignment_status_type_id not in
20: (select assignment_status_type_id
21: from per_assignment_status_types

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

14: into l_supervisor_id
15: from per_all_assignments_f
16: where per_all_assignments_f.person_id = l_current_person_id
17: and per_all_assignments_f.primary_flag = 'Y'
18: and per_all_assignments_f.assignment_type in ('E','C')
19: and per_all_assignments_f.assignment_status_type_id not in
20: (select assignment_status_type_id
21: from per_assignment_status_types
22: where per_system_status = 'TERM_ASSIGN')

Line 19: and per_all_assignments_f.assignment_status_type_id not in

15: from per_all_assignments_f
16: where per_all_assignments_f.person_id = l_current_person_id
17: and per_all_assignments_f.primary_flag = 'Y'
18: and per_all_assignments_f.assignment_type in ('E','C')
19: and per_all_assignments_f.assignment_status_type_id not in
20: (select assignment_status_type_id
21: from per_assignment_status_types
22: where per_system_status = 'TERM_ASSIGN')
23: and trunc(p_effective_date)

Line 24: between per_all_assignments_f.effective_start_date

20: (select assignment_status_type_id
21: from per_assignment_status_types
22: where per_system_status = 'TERM_ASSIGN')
23: and trunc(p_effective_date)
24: between per_all_assignments_f.effective_start_date
25: and per_all_assignments_f.effective_end_date;
26: exception
27: when no_data_found then
28: return 'N';

Line 25: and per_all_assignments_f.effective_end_date;

21: from per_assignment_status_types
22: where per_system_status = 'TERM_ASSIGN')
23: and trunc(p_effective_date)
24: between per_all_assignments_f.effective_start_date
25: and per_all_assignments_f.effective_end_date;
26: exception
27: when no_data_found then
28: return 'N';
29: end;