eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SAMPLES_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 5128: HR_ORGANIZATION_INFORMATION O2

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'
5132: AND O2.ORG_INFORMATION2 = 'Y'

Line 5221: HR_ORGANIZATION_INFORMATION O2

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'
5225: AND O2.ORG_INFORMATION2 = 'Y'