[Home] [Help]
339: l_yes_no boolean := FALSE;
340: --
341: CURSOR c_get_tax_unit_id IS
342: SELECT tax_unit_id
343: FROM pay_assignment_actions
344: WHERE assignment_action_id = p_assignment_action_id;
345:
346:
347: CURSOR c_chk_govt_employer IS
540: CURSOR get_effective_date (p_quarter_start_date DATE,
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')
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:
1046: hr_utility.trace('lv_employer_count := '||lv_employer_count) ;
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,
1084: ff_database_items fdi1
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,
1135: ff_database_items fdi,
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,
1184: ff_archive_items fai3,
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
1243: and ppa.payroll_action_id = paa.payroll_action_id