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 438: FROM hr_organization_units hou

434: BEGIN
435: l_loc_id := null;
436: SELECT hou.location_id
437: INTO l_loc_id
438: FROM hr_organization_units hou
439: WHERE hou.organization_id = l_so_org_id;
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: IF p_created_from = 'RAXTRX' THEN

Line 460: hr_organization_units hrou

456: BEGIN
457: SELECT hrl.global_attribute1
458: INTO l_organization_class_code
459: FROM hr_locations hrl,
460: hr_organization_units hrou
461: WHERE hrou.organization_id = l_so_org_id
462: AND hrl.location_id = hrou.location_id;
463: EXCEPTION WHEN NO_DATA_FOUND THEN
464: IF p_created_from = 'RAXTRX' THEN

Line 1001: FROM hr_locations hl, hr_organization_units hou

997: BEGIN
998: BEGIN
999: SELECT hl.global_attribute7
1000: INTO l_br_numb_code
1001: FROM hr_locations hl, hr_organization_units hou
1002: WHERE hl.location_id = hou.location_id
1003: AND hou.organization_id = p_inv_org_id;
1004: EXCEPTION
1005: WHEN OTHERS THEN