296: , pay_assignment_actions paa
297: , pay_element_entries_f pee1
298: , pay_element_types_f pet
299: , pay_element_entries_f pee2
300: , hr_organization_units hou /*bug fix 4551283*/
301: /* Added for Pension changes */
302: , pay_input_values_f pivf
303: , pay_element_entry_values_f peev1
304: , pay_element_entry_values_f peev2
514: l_org_id NUMBER;
515:
516: CURSOR get_org_id( p_org_name VARCHAR2 ) IS
517: SELECT to_char(hou.organization_id)
518: FROM hr_organization_units hou
519: WHERE hou.name = p_org_name;
520:
521: BEGIN
522:
543: SELECT hoi2.ORG_INFORMATION2 TAX_RC
544: ,hoi2.ORG_INFORMATION3 AMB_RC
545: ,hoi2.ORG_INFORMATION4 SP_RC
546: ,hoi2.ORG_INFORMATION5 HOL_DAYS_RC
547: FROM HR_ORGANIZATION_UNITS hou
548: , HR_ORGANIZATION_INFORMATION hoi1
549: , HR_ORGANIZATION_INFORMATION hoi2
550: WHERE hou.business_group_id = p_business_group_id
551: and hoi1.organization_id = hou.organization_id