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 304: l_employee_number per_all_people_f.employee_number%TYPE;

300: -- parameter
301: ---------------------------------------------------------------------------
302: FUNCTION get_param_person_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
303: --
304: l_employee_number per_all_people_f.employee_number%TYPE;
305: l_person_id per_all_people_f.person_id%TYPE;
306: --
307: CURSOR get_person_id IS
308: SELECT person_id

Line 305: l_person_id per_all_people_f.person_id%TYPE;

301: ---------------------------------------------------------------------------
302: FUNCTION get_param_person_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
303: --
304: l_employee_number per_all_people_f.employee_number%TYPE;
305: l_person_id per_all_people_f.person_id%TYPE;
306: --
307: CURSOR get_person_id IS
308: SELECT person_id
309: FROM per_all_people_f

Line 309: FROM per_all_people_f

305: l_person_id per_all_people_f.person_id%TYPE;
306: --
307: CURSOR get_person_id IS
308: SELECT person_id
309: FROM per_all_people_f
310: WHERE employee_number = l_employee_number
311: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
312: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
313: --