26: CURSOR csr_reg_legal_name
27: IS
28: SELECT hoi2.org_information4
29: FROM per_assignments_f peaf
30: ,hr_soft_coding_keyflex hrscf
31: ,hr_organization_information hoi
32: ,hr_organization_units hou
33: ,hr_organization_information hoi2
34: , pay_assignment_actions paa
792:
793: CURSOR csr_get_tax_unit_id
794: IS
795: SELECT hsck.segment1
796: FROM hr_soft_coding_keyflex hsck
797: , per_assignments_f paf
798: , pay_assignment_actions paa
799: , pay_payroll_actions ppa
800: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id