eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_ALL_PEOPLE_F

Line 341: l_employee_number per_all_people_f.employee_number%TYPE;

337: -- parameter
338: ---------------------------------------------------------------------------
339: FUNCTION get_param_person_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
340: --
341: l_employee_number per_all_people_f.employee_number%TYPE;
342: l_person_id per_all_people_f.person_id%TYPE;
343: --
344: CURSOR get_person_id IS
345: SELECT person_id

Line 342: l_person_id per_all_people_f.person_id%TYPE;

338: ---------------------------------------------------------------------------
339: FUNCTION get_param_person_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
340: --
341: l_employee_number per_all_people_f.employee_number%TYPE;
342: l_person_id per_all_people_f.person_id%TYPE;
343: --
344: CURSOR get_person_id IS
345: SELECT person_id
346: FROM per_all_people_f

Line 346: FROM per_all_people_f

342: l_person_id per_all_people_f.person_id%TYPE;
343: --
344: CURSOR get_person_id IS
345: SELECT person_id
346: FROM per_all_people_f
347: WHERE employee_number = l_employee_number
348: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
349: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
350: --