DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 5447: FROM HR_ORGANIZATION_INFORMATION OI1,

5443:
5444:
5445: CURSOR l_get_sob_csr IS
5446: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID
5447: FROM HR_ORGANIZATION_INFORMATION OI1,
5448: HR_ORGANIZATION_INFORMATION OI2,
5449: HR_ALL_ORGANIZATION_UNITS OU
5450: WHERE OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
5451: OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID AND

Line 5448: HR_ORGANIZATION_INFORMATION OI2,

5444:
5445: CURSOR l_get_sob_csr IS
5446: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID
5447: FROM HR_ORGANIZATION_INFORMATION OI1,
5448: HR_ORGANIZATION_INFORMATION OI2,
5449: HR_ALL_ORGANIZATION_UNITS OU
5450: WHERE OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
5451: OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
5452: OI1.ORG_INFORMATION_CONTEXT = 'CLASS' AND