[Home] [Help]
533: /*Since we are using the Date Based approach to fetch the Balances
534: of the assignment, we need to ensure that on the Date we pass for the
535: assignment, the Assignment record is present.Incase, the employee
536: is terminated, we need to pass the last effective date applicable to the
537: assignment to fetch the balances.This we do by referring to the pay_payroll_actions
538: table to find the maximum effective_date of this person in this Quarter.*/
539:
540: CURSOR get_effective_date (p_quarter_start_date DATE,
541: p_quarter_end_date DATE) IS
541: p_quarter_end_date DATE) IS
542: select max(ppa.effective_date)
543: from per_all_assignments_f asg,
544: pay_assignment_actions paa,
545: pay_payroll_actions ppa
546: where ppa.effective_date between p_quarter_start_date
547: and p_quarter_end_date
548: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
549: and paa.payroll_action_id = ppa.payroll_action_id
1037: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
1038:
1039: select count(distinct tax_unit_id)
1040: into lv_employer_count
1041: from pay_payroll_actions ppa,
1042: pay_assignment_actions paa
1043: where ppa.payroll_action_id = p_payroll_action_id
1044: and ppa.payroll_action_id = paa.payroll_action_id ;
1045:
1075: IF p_state = 'MI' THEN
1076:
1077: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
1078: into lv_employer_total_wages
1079: from pay_payroll_actions ppa,
1080: pay_assignment_actions paa,
1081: ff_archive_items fai,
1082: ff_archive_items fai1,
1083: ff_database_items fdi,
1126: IF p_state='MI' THEN
1127:
1128: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')) - to_number(nvl(fai2.value, '0')))
1129: into lv_excess_wages
1130: from pay_payroll_actions ppa,
1131: pay_assignment_actions paa,
1132: ff_archive_items fai,
1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1175: into p_sui_subj,
1176: p_sui_pre_tax,
1177: p_sui_taxable,
1178: p_sui_gross
1179: from pay_payroll_actions ppa,
1180: pay_assignment_actions paa,
1181: ff_archive_items fai,
1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1234:
1235: cursor c_get_emp_wages(c_payroll_action_id number,
1236: c_tax_unit_id number) is /* It will fetch required Person level DBIs*/
1237: select paa.assignment_action_id paa_id, fdi.user_name dbi_name, nvl(fai.value, '0') value
1238: from pay_payroll_actions ppa,
1239: pay_assignment_actions paa,
1240: ff_archive_items fai,
1241: ff_database_items fdi
1242: where ppa.payroll_action_id = c_payroll_action_id --1436067