[Home] [Help]
89: l_tax_year := hruserdt.get_table_value(p_bus_grp_id,
90: 'PAY GB P11D Mileage Extract',
91: 'Parameter Value',
92: 'Tax Year (YYYY)',
93: ben_ext_person.g_effective_date );
94:
95:
96: EXCEPTION
97:
198: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
199: 'PAY GB P11D Mileage Extract',
200: 'Parameter Value',
201: 'Extract End Date (DD-MON-YYYY)',
202: ben_ext_person.g_effective_date ));
203:
204:
205: l_ext_end_date := nvl(l_ext_end_date,get_tax_year_end(p_bus_group_id));
206:
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: --
241: BEGIN
242:
243: -- Get user Table Value
248: l_payroll_name := hruserdt.get_table_value(p_bus_group_id,
249: 'PAY GB P11D Mileage Extract',
250: 'Parameter Value',
251: 'Payroll Name',
252: ben_ext_person.g_effective_date );
253: --
254: -- Get Payroll_id
255: OPEN get_payroll_id;
256: FETCH get_payroll_id INTO l_payroll_id;
282: l_tax_dist := hruserdt.get_table_value(p_bus_group_id,
283: 'PAY GB P11D Mileage Extract',
284: 'Parameter Value',
285: 'Tax District Reference',
286: ben_ext_person.g_effective_date );
287: --
288: EXCEPTION
289: WHEN others THEN
290: l_tax_dist := NULL;
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: --
314: BEGIN
315: BEGIN
316: -- Get Employee Number Parameter Value
317: l_employee_number := hruserdt.get_table_value(p_bus_group_id,
318: 'PAY GB P11D Mileage Extract',
319: 'Parameter Value',
320: 'Employee Number',
321: ben_ext_person.g_effective_date );
322: --
323: -- Get Person Id
324: OPEN get_person_id;
325: FETCH get_person_id INTO l_person_id;
357: l_consolidation_set := hruserdt.get_table_value(p_bus_group_id,
358: 'PAY GB P11D Mileage Extract',
359: 'Parameter Value',
360: 'Consolidation Set',
361: ben_ext_person.g_effective_date );
362: --
363: -- Get Consolidation Set Id
364: OPEN get_consolidation_set_id;
365: FETCH get_consolidation_set_id INTO l_consolidation_set_id;
398: l_assignment_set := hruserdt.get_table_value(p_bus_group_id,
399: 'PAY GB P11D Mileage Extract',
400: 'Parameter Value',
401: 'Assignment Set',
402: ben_ext_person.g_effective_date );
403: --
404: -- Get Assignment Set Id
405: OPEN get_assignment_set_id;
406: FETCH get_assignment_set_id INTO l_assignment_set_id;
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
458: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
459: AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
460: AND asg.effective_start_date < l_ext_end_date
461: AND asg.effective_end_date > ben_start_date(p_asg_id);
462: --
466: hr_assignment_sets has,
467: per_all_assignments_f paaf
468: WHERE has.assignment_set_id = l_ext_asg_set_id
469: AND paaf.assignment_id = p_asg_id
470: -- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
471: AND has.assignment_set_id = hasa.assignment_set_id (+)
472: AND NVL (hasa.assignment_id, paaf.assignment_id) = paaf.assignment_id
473: AND NVL (hasa.include_or_exclude, 'I') = 'I'
474: AND NVL (has.payroll_id, paaf.payroll_id) = paaf.payroll_id;