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.PAY_US_GEOCODE_REPORT_PKG dependencies on HR_LOCATIONS_ALL

Line 2992: WHERE pugp.table_name in ('PER_ADDRESSES','HR_LOCATIONS_ALL')

2988:
2989: SELECT pugp.new_juri_code,pugp.description
2990: FROM pay_us_geo_update pugp,
2991: pay_patch_status pps
2992: WHERE pugp.table_name in ('PER_ADDRESSES','HR_LOCATIONS_ALL')
2993: AND pugp.process_type = 'CN'
2994: AND pugp.id = pps.id
2995: AND pps.patch_name = cp_geocode_patch_name
2996: ORDER BY pugp.description;

Line 3516: from hr_locations_all hla

3512: hla.town_or_city "City Name",
3513: hla.region_1 "County",
3514: hla.region_2 "State",
3515: hla.postal_code "Zipcode"
3516: from hr_locations_all hla
3517: where hla.location_id in
3518: (select distinct location_id
3519: from per_assignments_f paf,
3520: pay_us_emp_city_tax_rules_f pctr

Line 4156: hr_locations_all hl,

4152: pumg2.city_name new_city_name,
4153: substr(pgu.description,1,instr(pgu.description,':')-1)
4154: from pay_patch_status pps,
4155: pay_us_geo_update pgu,
4156: hr_locations_all hl,
4157: pay_us_modified_geocodes pumg1,
4158: pay_us_modified_geocodes pumg2
4159: where pgu.process_type = 'CY'
4160: and pgu.table_name = 'HR_LOCATIONS_ALL'

Line 4160: and pgu.table_name = 'HR_LOCATIONS_ALL'

4156: hr_locations_all hl,
4157: pay_us_modified_geocodes pumg1,
4158: pay_us_modified_geocodes pumg2
4159: where pgu.process_type = 'CY'
4160: and pgu.table_name = 'HR_LOCATIONS_ALL'
4161: and hl.location_id = pgu.table_value_id
4162: and pgu.process_mode = cp_process_mode
4163: and pgu.id = pps.id
4164: and pgu.new_juri_code = pumg1.state_code||'-'||

Line 4245: ln_location_name hr_locations_all.location_code%TYPE;

4241: ln_old_city_name pay_us_modified_geocodes.city_name%TYPE;
4242: ln_new_city_name pay_us_modified_geocodes.city_name%TYPE;
4243: ln_update_description pay_us_geo_update.description%TYPE;
4244:
4245: ln_location_name hr_locations_all.location_code%TYPE;
4246: ln_location_id hr_locations_all.location_id%TYPE;
4247:
4248: ln_organization_name hr_organization_units.name%TYPE;
4249: ln_organization_id hr_organization_units.organization_id%TYPE;

Line 4246: ln_location_id hr_locations_all.location_id%TYPE;

4242: ln_new_city_name pay_us_modified_geocodes.city_name%TYPE;
4243: ln_update_description pay_us_geo_update.description%TYPE;
4244:
4245: ln_location_name hr_locations_all.location_code%TYPE;
4246: ln_location_id hr_locations_all.location_id%TYPE;
4247:
4248: ln_organization_name hr_organization_units.name%TYPE;
4249: ln_organization_id hr_organization_units.organization_id%TYPE;
4250: