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
277: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
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
277: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
278: AND HOI1.ORG_INFORMATION1 = 'INV'