APPS.PER_CN_ASG_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 53: l_business_group_id per_all_people_f.business_group_id%TYPE;

49: ,p_person_id IN NUMBER DEFAULT null
50: ,p_assignment_id IN NUMBER DEFAULT null) AS
51:
52: l_proc VARCHAR2(72);
53: l_business_group_id per_all_people_f.business_group_id%TYPE;
54: l_trunc_effective_date DATE;
55:
56: CURSOR csr_business_group_per(p_person_id NUMBER,p_effective_date DATE) IS
57: SELECT business_group_id

Line 58: FROM per_all_people_f

54: l_trunc_effective_date DATE;
55:
56: CURSOR csr_business_group_per(p_person_id NUMBER,p_effective_date DATE) IS
57: SELECT business_group_id
58: FROM per_all_people_f
59: WHERE person_id = p_person_id
60: AND p_effective_date BETWEEN effective_start_date
61: AND effective_end_date;
62: