DBA Data[Home] [Help]

APPS.OKS_MASSCHANGE_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 13291: , HR_ORGANIZATION_INFORMATION HOI2

13287:
13288: SELECT gcck.concatenated_segments
13289: From gl_code_combinations_kfv gcck
13290: , HR_ALL_ORGANIZATION_UNITS HOU
13291: , HR_ORGANIZATION_INFORMATION HOI2
13292: , GL_LEDGERS GSOB
13293: WHERE HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
13294: AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
13295: AND HOI2.ORG_INFORMATION1 = TO_CHAR(GSOB.LEDGER_ID)