APPS.OE_FLEX_COGS_PUB dependencies on HR_ORGANIZATION_UNITS

Line 272: FROM HR_ORGANIZATION_UNITS HOU ,

268:
269: SELECT /*+ ordered use_nl(HOI1,HOI2,GSOB) */
270: GSOB.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
271: INTO l_chart_of_accounts_id
272: FROM HR_ORGANIZATION_UNITS HOU ,
273: HR_ORGANIZATION_INFORMATION HOI1 ,
274: HR_ORGANIZATION_INFORMATION HOI2 ,
275: GL_SETS_OF_BOOKS GSOB
276: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID