APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on PER_ALL_PEOPLE_F

Line 139: l_employee_number per_all_people_f.employee_number%TYPE;

135: -- parameter
136: ---------------------------------------------------------------------------
137: FUNCTION get_param_person_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
138: --
139: l_employee_number per_all_people_f.employee_number%TYPE;
140: l_person_id per_all_people_f.person_id%TYPE;
141: --
142: CURSOR get_person_id IS
143: SELECT person_id

Line 140: l_person_id per_all_people_f.person_id%TYPE;

136: ---------------------------------------------------------------------------
137: FUNCTION get_param_person_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
138: --
139: l_employee_number per_all_people_f.employee_number%TYPE;
140: l_person_id per_all_people_f.person_id%TYPE;
141: --
142: CURSOR get_person_id IS
143: SELECT person_id
144: FROM per_all_people_f

Line 144: FROM per_all_people_f

140: l_person_id per_all_people_f.person_id%TYPE;
141: --
142: CURSOR get_person_id IS
143: SELECT person_id
144: FROM per_all_people_f
145: WHERE employee_number = l_employee_number
146: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
147: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
148: --