DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 5795: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,

5791: -- Bug# 5226352
5792: -- Commented the above cursor definition and modified to fix performance issues
5793: CURSOR Cur_operating_unit IS
5794: SELECT OTL.name
5795: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,
5796: HR_ORGANIZATION_INFORMATION O2
5797: WHERE OTL.organization_id = p_org_id
5798: AND OTL.ORGANIZATION_ID = O2.ORGANIZATION_ID
5799: AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'

Line 5888: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,

5884: -- Bug# 5226352
5885: -- Commented the above cursor definition and modified to fix performance issues
5886: CURSOR Cur_operating_unit IS
5887: SELECT OTL.name
5888: FROM HR_ALL_ORGANIZATION_UNITS_TL OTL,
5889: HR_ORGANIZATION_INFORMATION O2
5890: WHERE OTL.organization_id = p_org_id
5891: AND OTL.ORGANIZATION_ID = O2.ORGANIZATION_ID
5892: AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'