[Home] [Help]
130: ,tbi.am_usc_mthly_cutoff_4
131: ,tbi.am_usc_wkly_cutoff_4
132: ,tbi.cd_usc_rate_5
133: --13359423
134: FROM hr_organization_information hoi
135: , hr_organization_units hou
136: , per_all_assignments_f asg
137: , per_all_people_f per
138: , pay_all_payrolls_f pay
232: ,tbi.am_usc_mthly_cutoff_4
233: ,tbi.am_usc_wkly_cutoff_4
234: ,tbi.cd_usc_rate_5
235: --13359423
236: FROM hr_organization_information hoi
237: , hr_organization_units hou
238: , per_all_assignments_f asg
239: , per_all_people_f per
240: , pay_all_payrolls_f pay
276: /* cursor csr_skipped_asg is
277: select pps_number, works_number from pay_ie_tax_body_interface
278: minus
279: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
280: FROM hr_organization_information hoi
281: , hr_organization_units hou
282: , per_all_assignments_f asg
283: , per_all_people_f per
284: , pay_all_payrolls_f pay
3319: , tbi.tot_tax_to_date/100 tot_tax_to_date
3320: , tbi.tot_pay_to_date/100 tot_pay_to_date
3321: , tbi.std_rate_of_tax std_rate_of_tax
3322: , tbi.higher_rate_of_tax higher_rate_of_tax
3323: FROM hr_organization_information hoi
3324: , hr_organization_units hou
3325: , per_all_assignments_f asg
3326: , per_all_people_f per
3327: , pay_all_payrolls_f pay
3385: , tbi.tot_tax_to_date/100 tot_tax_to_date
3386: , tbi.tot_pay_to_date/100 tot_pay_to_date
3387: , tbi.std_rate_of_tax std_rate_of_tax
3388: , tbi.higher_rate_of_tax higher_rate_of_tax
3389: FROM hr_organization_information hoi
3390: , hr_organization_units hou
3391: , per_all_assignments_f asg
3392: , per_all_people_f per
3393: , pay_all_payrolls_f pay
3429: /* cursor csr_skipped_asg is
3430: select pps_number, works_number from pay_ie_tax_body_interface
3431: minus
3432: SELECT distinct per.national_identifier pps_number, asg.assignment_number works_number
3433: FROM hr_organization_information hoi
3434: , hr_organization_units hou
3435: , per_all_assignments_f asg
3436: , per_all_people_f per
3437: , pay_all_payrolls_f pay