DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 807: , HR_ORGANIZATION_INFORMATION hoi1

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
811: and hoi1.organization_id = p_business_group_id

Line 808: , HR_ORGANIZATION_INFORMATION hoi2

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
811: and hoi1.organization_id = p_business_group_id
812: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'