DBA Data[Home] [Help]

APPS.OKS_REV_DISTR_PUB dependencies on GL_SETS_OF_BOOKS

Line 616: -- GL_SETS_OF_BOOKS GSOB

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)
620: -- AND HOU.ORGANIZATION_ID = P_ORG_ID;

Line 629: ,GL_SETS_OF_BOOKS GSOB

625: SELECT GSOB.CHART_OF_ACCOUNTS_ID
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