APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_ALL_PAYROLLS_F

Line 231: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

227: -- Description: This function gets id of payroll name parameter
228: ---------------------------------------------------------------------------
229: FUNCTION get_param_payroll_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
230: --
231: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
232: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
233: --
234: CURSOR get_payroll_id IS
235: SELECT payroll_id

Line 232: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

228: ---------------------------------------------------------------------------
229: FUNCTION get_param_payroll_id(p_bus_group_id IN NUMBER) RETURN NUMBER IS
230: --
231: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
232: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
233: --
234: CURSOR get_payroll_id IS
235: SELECT payroll_id
236: FROM pay_all_payrolls_f

Line 236: FROM pay_all_payrolls_f

232: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
233: --
234: CURSOR get_payroll_id IS
235: SELECT payroll_id
236: FROM pay_all_payrolls_f
237: WHERE payroll_name = l_payroll_name
238: AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
239: AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
240: --

Line 453: FROM pay_all_payrolls_f pp,

449: l_max_end_date DATE;
450: --
451: CURSOR get_asg_details(p_asg_id IN NUMBER) IS
452: SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
453: FROM pay_all_payrolls_f pp,
454: per_all_assignments_f asg,
455: hr_soft_coding_keyflex flex
456: WHERE asg.assignment_id = p_asg_id
457: AND asg.payroll_id = pp.payroll_id