[Home] [Help]
94: l_tax_year := hruserdt.get_table_value(p_bus_grp_id,
95: 'PAY GB P11d Mileage Extract',
96: 'Parameter Value',
97: 'Tax Year (YYYY)',
98: ben_ext_person.g_effective_date );
99:
100:
101: EXCEPTION
102:
201: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
202: 'PAY GB P11D Mileage Extract',
203: 'Parameter Value',
204: 'Extract Start Date (DD-MON-YYYY)',
205: ben_ext_person.g_effective_date ));
206:
207: l_ext_start_date := nvl(l_ext_start_date,get_tax_year_start(p_bus_group_id));
208:
209: EXCEPTION
235: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
236: 'PAY GB P11D Mileage Extract',
237: 'Parameter Value',
238: 'Extract End Date (DD-MON-YYYY)',
239: ben_ext_person.g_effective_date ));
240:
241:
242: l_ext_end_date := nvl(l_ext_end_date,get_tax_year_end(p_bus_group_id));
243:
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: --
278: BEGIN
279:
280: -- Get user Table Value
285: l_payroll_name := hruserdt.get_table_value(p_bus_group_id,
286: 'PAY GB P11D Mileage Extract',
287: 'Parameter Value',
288: 'Payroll Name',
289: ben_ext_person.g_effective_date );
290: --
291: -- Get Payroll_id
292: OPEN get_payroll_id;
293: FETCH get_payroll_id INTO l_payroll_id;
319: l_tax_dist := hruserdt.get_table_value(p_bus_group_id,
320: 'PAY GB P11D Mileage Extract',
321: 'Parameter Value',
322: 'Tax District Reference',
323: ben_ext_person.g_effective_date );
324: --
325: EXCEPTION
326: WHEN others THEN
327: l_tax_dist := NULL;
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: --
351: BEGIN
352: BEGIN
353: -- Get Employee Number Parameter Value
354: l_employee_number := hruserdt.get_table_value(p_bus_group_id,
355: 'PAY GB P11D Mileage Extract',
356: 'Parameter Value',
357: 'Employee Number',
358: ben_ext_person.g_effective_date );
359: --
360: -- Get Person Id
361: OPEN get_person_id;
362: FETCH get_person_id INTO l_person_id;
394: l_consolidation_set := hruserdt.get_table_value(p_bus_group_id,
395: 'PAY GB P11D Mileage Extract',
396: 'Parameter Value',
397: 'Consolidation Set',
398: ben_ext_person.g_effective_date );
399: --
400: -- Get Consolidation Set Id
401: OPEN get_consolidation_set_id;
402: FETCH get_consolidation_set_id INTO l_consolidation_set_id;
435: l_assignment_set := hruserdt.get_table_value(p_bus_group_id,
436: 'PAY GB P11D Mileage Extract',
437: 'Parameter Value',
438: 'Assignment Set',
439: ben_ext_person.g_effective_date );
440: --
441: -- Get Assignment Set Id
442: OPEN get_assignment_set_id;
443: FETCH get_assignment_set_id INTO l_assignment_set_id;
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
495: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
496: AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
497: AND asg.effective_start_date < l_ext_end_date
498: AND asg.effective_end_date > ben_start_date(p_asg_id);
499: --
503: hr_assignment_sets has,
504: per_all_assignments_f paaf
505: WHERE has.assignment_set_id = l_ext_asg_set_id
506: AND paaf.assignment_id = p_asg_id
507: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
508: AND has.assignment_set_id = hasa.assignment_set_id (+)
509: AND NVL (hasa.assignment_id, paaf.assignment_id) = paaf.assignment_id
510: AND NVL (hasa.include_or_exclude, 'I') = 'I'
511: AND NVL (has.payroll_id, paaf.payroll_id) = paaf.payroll_id;