APPS.OKS_REV_DISTR_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 609: -- FROM HR_ORGANIZATION_INFORMATION HOI1

605: -- ,MTL_PARAMETERS MP
606: -- ,FND_PRODUCT_GROUPS
607: -- WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
608: -- AND EXISTS ( SELECT 1
609: -- FROM HR_ORGANIZATION_INFORMATION HOI1
610: -- WHERE HOI1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
611: -- AND HOI1.ORG_INFORMATION1 = 'INV'
612: -- AND HOI1.ORG_INFORMATION2 = 'Y'
613: -- AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS')

Line 615: -- FROM HR_ORGANIZATION_INFORMATION HOI2,

611: -- AND HOI1.ORG_INFORMATION1 = 'INV'
612: -- AND HOI1.ORG_INFORMATION2 = 'Y'
613: -- AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS')
614: -- AND EXISTS ( SELECT 1
615: -- FROM HR_ORGANIZATION_INFORMATION HOI2,
616: -- GL_SETS_OF_BOOKS GSOB
617: -- WHERE HOI2.ORGANIZATION_ID = HOU.ORGANIZATION_ID
618: -- AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
619: -- AND TO_NUMBER(HOI2.ORG_INFORMATION1) = GSOB.SET_OF_BOOKS_ID)

Line 630: ,HR_ORGANIZATION_INFORMATION HOI2

626: FROM HR_ORGANIZATION_UNITS HOU
627: ,MTL_PARAMETERS MP
628: --,FND_PRODUCT_GROUPS
629: ,GL_SETS_OF_BOOKS GSOB
630: ,HR_ORGANIZATION_INFORMATION HOI2
631: WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
632: AND EXISTS ( SELECT 1
633: FROM HR_ORGANIZATION_INFORMATION HOI1
634: WHERE HOI1.ORGANIZATION_ID = HOU.ORGANIZATION_ID

Line 633: FROM HR_ORGANIZATION_INFORMATION HOI1

629: ,GL_SETS_OF_BOOKS GSOB
630: ,HR_ORGANIZATION_INFORMATION HOI2
631: WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
632: AND EXISTS ( SELECT 1
633: FROM HR_ORGANIZATION_INFORMATION HOI1
634: WHERE HOI1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
635: AND HOI1.ORG_INFORMATION1 = 'INV'
636: AND HOI1.ORG_INFORMATION2 = 'Y'
637: AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS')