DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 5127: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,

5123: -- Bug# 5226352
5124: -- Commented the above cursor definition and modified to fix performance issues
5125: CURSOR Cur_operating_unit IS
5126: SELECT OTL.name
5127: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,
5128: HR_ORGANIZATION_INFORMATION O2
5129: WHERE OTL.organization_id = p_org_id
5130: AND OTL.ORGANIZATION_ID = O2.ORGANIZATION_ID
5131: AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'

Line 5220: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,

5216: -- Bug# 5226352
5217: -- Commented the above cursor definition and modified to fix performance issues
5218: CURSOR Cur_operating_unit IS
5219: SELECT OTL.name
5220: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,
5221: HR_ORGANIZATION_INFORMATION O2
5222: WHERE OTL.organization_id = p_org_id
5223: AND OTL.ORGANIZATION_ID = O2.ORGANIZATION_ID
5224: AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'