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.JL_AR_DOC_NUMBERING_PKG dependencies on HR_ORGANIZATION_UNITS

Line 424: FROM hr_organization_units hou

420: BEGIN
421: l_loc_id := null;
422: SELECT hou.location_id
423: INTO l_loc_id
424: FROM hr_organization_units hou
425: WHERE hou.organization_id = l_so_org_id;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: IF p_created_from = 'RAXTRX' THEN

Line 446: hr_organization_units hrou

442: BEGIN
443: SELECT hrl.global_attribute1
444: INTO l_organization_class_code
445: FROM hr_locations hrl,
446: hr_organization_units hrou
447: WHERE hrou.organization_id = l_so_org_id
448: AND hrl.location_id = hrou.location_id;
449: EXCEPTION WHEN NO_DATA_FOUND THEN
450: IF p_created_from = 'RAXTRX' THEN

Line 987: FROM hr_locations hl, hr_organization_units hou

983: BEGIN
984: BEGIN
985: SELECT hl.global_attribute7
986: INTO l_br_numb_code
987: FROM hr_locations hl, hr_organization_units hou
988: WHERE hl.location_id = hou.location_id
989: AND hou.organization_id = p_inv_org_id;
990: EXCEPTION
991: WHEN OTHERS THEN