APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 557: , hr_organization_units hou /*bug fix 4551283*/

553: , pay_assignment_actions paa
554: , pay_element_entries_f pee1
555: , pay_element_types_f pet
556: , pay_element_entries_f pee2
557: , hr_organization_units hou /*bug fix 4551283*/
558: /* Added for Pension changes */
559: , pay_input_values_f pivf
560: , pay_element_entry_values_f peev1
561: , pay_element_entry_values_f peev2

Line 777: FROM hr_organization_units hou

773: l_org_id NUMBER;
774:
775: CURSOR get_org_id( p_org_name VARCHAR2 ) IS
776: SELECT to_char(hou.organization_id)
777: FROM hr_organization_units hou
778: WHERE hou.name = p_org_name;
779:
780: BEGIN
781:

Line 806: FROM HR_ORGANIZATION_UNITS hou

802: SELECT hoi2.ORG_INFORMATION2 TAX_RC
803: ,hoi2.ORG_INFORMATION3 AMB_RC
804: ,hoi2.ORG_INFORMATION4 SP_RC
805: ,hoi2.ORG_INFORMATION5 HOL_DAYS_RC
806: FROM HR_ORGANIZATION_UNITS hou
807: , HR_ORGANIZATION_INFORMATION hoi1
808: , HR_ORGANIZATION_INFORMATION hoi2
809: WHERE hou.business_group_id = p_business_group_id
810: and hoi1.organization_id = hou.organization_id