APPS.HXC_TIMEKEEPER_WF_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 31: from per_all_assignments_f asg

27: is
28:
29: cursor csr_get_supervisor(b_person_id number, b_effective_date date) is
30: select asg.supervisor_id
31: from per_all_assignments_f asg
32: where asg.person_id = b_person_id
33: and TRUNC(b_effective_date) between TRUNC(asg.effective_Start_date) and TRUNC(asg.effective_end_date)
34: and asg.primary_flag = 'Y'
35: and asg.assignment_type in ('E','C');

Line 37: l_supervisor_id per_all_assignments_f.person_id%type;

33: and TRUNC(b_effective_date) between TRUNC(asg.effective_Start_date) and TRUNC(asg.effective_end_date)
34: and asg.primary_flag = 'Y'
35: and asg.assignment_type in ('E','C');
36:
37: l_supervisor_id per_all_assignments_f.person_id%type;
38: begin
39: open csr_get_supervisor(p_person_id, trunc(p_effective_date));
40: fetch csr_get_supervisor into l_supervisor_id;
41: close csr_get_supervisor;