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_BR_SPED_PUB dependencies on HZ_LOCATIONS

Line 437: hz_locations loc

433: identifier_value state
434: FROM
435: hz_geography_identifiers geo_ident,
436: hz_geo_name_references geo_ref,
437: hz_locations loc
438: WHERE
439: loc.location_id = P_LOCATION_ID
440: and loc.location_id = geo_ref.location_id
441: and geo_ref.geography_type = 'STATE'

Line 453: hz_locations loc

449: identifier_value city
450: FROM
451: hz_geography_identifiers geo_ident,
452: hz_geo_name_references geo_ref,
453: hz_locations loc
454: WHERE
455: loc.location_id = P_LOCATION_ID
456: and loc.location_id = geo_ref.location_id
457: and geo_ref.geography_type = 'CITY'

Line 467: FROM hz_locations

463: SELECT meaning
464: FROM FND_LOOKUPS
465: WHERE lookup_type = 'JLBR_CBANK_COUNTRY_CODES'
466: and lookup_code = (SELECT country
467: FROM hz_locations
468: WHERE location_id = P_LOCATION_ID);
469:
470: CURSOR c_valid_location IS
471: SELECT

Line 473: FROM HZ_LOCATIONS

469:
470: CURSOR c_valid_location IS
471: SELECT
472: 'Yes' as isexist
473: FROM HZ_LOCATIONS
474: WHERE
475: location_id = P_LOCATION_ID;
476:
477: