DBA Data[Home] [Help]

APPS.OKS_REV_DISTR_PUB dependencies on HR_ORGANIZATION_UNITS

Line 604: -- FROM hr_organization_units HOU

600:
601: --Cursor modified as part of bug# 3599223
602: -- CURSOR CUR_CHART_ACC Is
603: -- SELECT HOU.ORGANIZATION_ID
604: -- FROM hr_organization_units HOU
605: -- ,MTL_PARAMETERS MP
606: -- ,FND_PRODUCT_GROUPS
607: -- WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
608: -- AND EXISTS ( SELECT 1

Line 626: FROM HR_ORGANIZATION_UNITS HOU

622: --Commented the FND_PRODUCT_GROUPS in the select clause to prevent the
623: --Merge cartesian join
624: CURSOR CUR_CHART_ACC Is
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