DBA Data[Home] [Help]

APPS.OKC_CONTEXT dependencies on HR_ORGANIZATION_INFORMATION

Line 22: HR_ORGANIZATION_INFORMATION OI1,

18:
19: CURSOR c_bus_grp(p_id IN NUMBER) IS
20: SELECT business_group_id
21: FROM HR_ALL_ORGANIZATION_UNITS OU,
22: HR_ORGANIZATION_INFORMATION OI1,
23: HR_ORGANIZATION_INFORMATION OI2
24: WHERE OU.ORGANIZATION_ID = p_id
25: AND OI1.ORG_INFORMATION1 = 'OPERATING_UNIT'
26: AND OI2.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'

Line 23: HR_ORGANIZATION_INFORMATION OI2

19: CURSOR c_bus_grp(p_id IN NUMBER) IS
20: SELECT business_group_id
21: FROM HR_ALL_ORGANIZATION_UNITS OU,
22: HR_ORGANIZATION_INFORMATION OI1,
23: HR_ORGANIZATION_INFORMATION OI2
24: WHERE OU.ORGANIZATION_ID = p_id
25: AND OI1.ORG_INFORMATION1 = 'OPERATING_UNIT'
26: AND OI2.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
27: AND OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID