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.AR_GTA_CONSOLIDATE_PROC dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 102: l_org_name hr_all_organization_units_tl.NAME%TYPE;

98: l_succ_unm NUMBER;
99: l_warn_unm NUMBER;
100: l_error_unm NUMBER;
101: l_org_id NUMBER(15);
102: l_org_name hr_all_organization_units_tl.NAME%TYPE;
103: CURSOR c_consol_seq(l_status IN VARCHAR2) IS --Yao Zhang add for bug 14462789
104: SELECT jgct.seq FROM AR_gta_consol_temp jgct WHERE status = l_status;
105: BEGIN
106: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 123: FROM hr_all_organization_units o, hr_all_organization_units_tl otl

119:
120: BEGIN
121: SELECT otl.NAME
122: INTO l_org_name
123: FROM hr_all_organization_units o, hr_all_organization_units_tl otl
124: WHERE o.organization_id = otl.organization_id
125: AND otl.LANGUAGE = userenv('LANG')
126: AND o.organization_id = l_org_id;
127: EXCEPTION