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.

[Home] [Help]

APPS.JL_BR_SPED_PUB dependencies on HZ_LOCATIONS

Line 443: hz_locations loc

439: identifier_value state
440: FROM
441: hz_geography_identifiers geo_ident,
442: hz_geo_name_references geo_ref,
443: hz_locations loc
444: WHERE
445: loc.location_id = P_LOCATION_ID
446: and loc.location_id = geo_ref.location_id
447: and geo_ref.geography_type = 'STATE'

Line 459: hz_locations loc

455: identifier_value city
456: FROM
457: hz_geography_identifiers geo_ident,
458: hz_geo_name_references geo_ref,
459: hz_locations loc
460: WHERE
461: loc.location_id = P_LOCATION_ID
462: and loc.location_id = geo_ref.location_id
463: and geo_ref.geography_type = 'CITY'

Line 473: FROM hz_locations

469: SELECT meaning
470: FROM FND_LOOKUPS
471: WHERE lookup_type = 'JLBR_CBANK_COUNTRY_CODES'
472: and lookup_code = (SELECT country
473: FROM hz_locations
474: WHERE location_id = P_LOCATION_ID);
475:
476: CURSOR c_valid_location IS
477: SELECT

Line 479: FROM HZ_LOCATIONS

475:
476: CURSOR c_valid_location IS
477: SELECT
478: 'Yes' as isexist
479: FROM HZ_LOCATIONS
480: WHERE
481: location_id = P_LOCATION_ID;
482:
483: