[Home] [Help]
245:
246: function periods_since_hire_date
247: (
248: p_payroll_id in number,
249: p_assignment_id in per_all_assignments_f.assignment_id%type,
250: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141
251: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */
252: p_period_num in number,
253: p_period_start in date,
269: Enrolled into the legal employer existing as of this period start date */
270:
271: /*Bug 4474896 - Modified cursor to pick the correct effective start date for the legal employer*/
272:
273: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is
274: select min(effective_start_date)
275: from per_all_assignments_f paf,
276: hr_soft_coding_keyflex hsck
277: where paf.assignment_id = c_assignment_id
271: /*Bug 4474896 - Modified cursor to pick the correct effective start date for the legal employer*/
272:
273: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is
274: select min(effective_start_date)
275: from per_all_assignments_f paf,
276: hr_soft_coding_keyflex hsck
277: where paf.assignment_id = c_assignment_id
278: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
279: and hsck.segment1 = p_tax_unit_id
494: per tax spread deductions for the previous year when total average earnings are negative */
495: /* Bug#4467198 - Modified the function to take care of legal employer changes. Introduced following
496: parameters in the function p_use_tax_flag, p_payroll_id, p_assignment_action_id*/
497: FUNCTION calculate_asg_prev_value
498: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
499: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
500: p_date_earned in date,
501: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
502: p_assignment_action_id IN number,
551: -- If there exists any LE changes, then it gets the max
552: -- Assignment Action ID .
553: -----------------------------------------------------------------------
554: CURSOR c_get_prev_year_max_asg_act_id
555: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
556: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
557: c_fin_start_date in date,
558: c_fin_end_date in date)
559: IS
567: (
568: SELECT MAX(paa.action_sequence)
569: FROM pay_assignment_actions paa,
570: pay_payroll_actions ppa,
571: per_all_assignments_f paaf
572: WHERE ppa.business_group_id = c_business_group_id
573: AND paaf.assignment_id = c_assignment_id
574: AND paa.assignment_id = paaf.assignment_id
575: AND paa.action_status='C'
581: ORDER BY date_earned desc;
582:
583:
584: CURSOR c_get_pre_le_max_asg_act_id
585: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
586: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
587: c_fin_start_date in date,
588: c_fin_end_date in date)
589: IS
597: (
598: SELECT MAX(paa.action_sequence)
599: FROM pay_assignment_actions paa,
600: pay_payroll_actions ppa,
601: per_all_assignments_f paaf
602: WHERE ppa.business_group_id = c_business_group_id
603: AND paaf.assignment_id = c_assignment_id
604: AND paa.action_status='C'
605: AND paa.assignment_id = paaf.assignment_id
658: AND ppa.payroll_action_id = paa.payroll_action_id;
659:
660: /* Bug#4467198 - Use the below cursor to check if this is the first for the assignment in this year*/
661:
662: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
663: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
664: c_start_date in date,
665: c_end_date in date)
666: IS
2049: end calculate_tax;
2050:
2051:
2052:
2053: function check_fixed_deduction(p_assignment_id in per_all_assignments_f.assignment_id%TYPE, p_date_earned in date)
2054: return varchar2 is
2055: /* Bug 4374115 - Added check for Reverse Runs */
2056: cursor check_fixed_deduction(p_assignment_id in number, p_date_earned in date)
2057: is
2063: pay_run_results prr,
2064: pay_assignment_actions paa,
2065: pay_payroll_actions ppa,
2066: per_time_periods ptp,
2067: per_all_assignments_f paaf
2068: where pet.element_name = 'Extra Withholding Payments'
2069: and piv.name='Withholding Amount'
2070: and pet.element_type_id=piv.element_type_id
2071: and piv.input_value_id=prrv.input_value_id
2303: FUNCTION get_salary_basis_hours
2304: (
2305: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
2306: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
2307: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
2308: )
2309: RETURN NUMBER IS
2310:
2311: l_element_type_id pay_element_entries_f.element_entry_id%TYPE;
2666: end;
2667:
2668: /* bug6809877 - Adeed new function get_etp_pay_component */
2669: function get_etp_pay_component
2670: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
2671: p_date_earned in date) return varchar2 is
2672:
2673: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,
2674: c_date_earned date) is
2669: function get_etp_pay_component
2670: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
2671: p_date_earned in date) return varchar2 is
2672:
2673: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,
2674: c_date_earned date) is
2675: select peev.screen_entry_value
2676: from pay_element_types_f pet,
2677: pay_input_values_f piv,