DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 548: , HR_ORGANIZATION_INFORMATION hoi1

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

Line 549: , HR_ORGANIZATION_INFORMATION hoi2

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