APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_ALL_PAYROLLS_F

Line 268: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

264: -- Description: This function gets id of payroll name parameter
265: ---------------------------------------------------------------------------
266: FUNCTION get_param_payroll_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
267: --
268: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
269: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
270: --
271: CURSOR get_payroll_id IS
272: SELECT payroll_id

Line 269: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

265: ---------------------------------------------------------------------------
266: FUNCTION get_param_payroll_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
267: --
268: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
269: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
270: --
271: CURSOR get_payroll_id IS
272: SELECT payroll_id
273: FROM pay_all_payrolls_f

Line 273: FROM pay_all_payrolls_f

269: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
270: --
271: CURSOR get_payroll_id IS
272: SELECT payroll_id
273: FROM pay_all_payrolls_f
274: WHERE payroll_name = l_payroll_name
275: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
276: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
277: --

Line 490: FROM pay_all_payrolls_f pp,

486: l_max_end_date DATE;
487: --
488: CURSOR get_asg_details(p_asg_id IN NUMBER) IS
489: SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
490: FROM pay_all_payrolls_f pp,
491: per_all_assignments_f asg,
492: hr_soft_coding_keyflex flex
493: WHERE asg.assignment_id = p_asg_id
494: AND asg.payroll_id = pp.payroll_id