13286: CURSOR get_ccid (p_ccid IN NUmber, p_organization_id Number) IS
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'