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_IP_RULES dependencies on HR_LOCATIONS

Line 217: FROM hr_locations location

213: SELECT location.address_line_1,
214: location.address_line_2, location.address_line_3,
215: location.town_or_city, location.postal_code,
216: location.country,location.region_2
217: FROM hr_locations location
218: WHERE location.location_id = p_location_id;
219:
220: CURSOR c_get_ee_information(p_asg_action_id number) IS
221: SELECT ppf.per_information1,

Line 274: lv_address_line1 hr_locations.address_line_1%TYPE;

270: ln_bus_grp_id number;
271: lv_legislation_code varchar2(3);
272: lv_org_name hr_organization_units.name%TYPE;
273: ln_location_id hr_organization_units.location_id%TYPE;
274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;

Line 275: lv_address_line2 hr_locations.address_line_2%TYPE;

271: lv_legislation_code varchar2(3);
272: lv_org_name hr_organization_units.name%TYPE;
273: ln_location_id hr_organization_units.location_id%TYPE;
274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;

Line 276: lv_address_line3 hr_locations.address_line_3%TYPE;

272: lv_org_name hr_organization_units.name%TYPE;
273: ln_location_id hr_organization_units.location_id%TYPE;
274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;

Line 277: lv_town_or_city hr_locations.town_or_city%TYPE;

273: ln_location_id hr_organization_units.location_id%TYPE;
274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;

Line 278: lv_postal_code hr_locations.postal_code%TYPE;

274: lv_address_line1 hr_locations.address_line_1%TYPE;
275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;

Line 279: lv_country hr_locations.country%TYPE;

275: lv_address_line2 hr_locations.address_line_2%TYPE;
276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;

Line 280: lv_state hr_locations.region_2%TYPE;

276: lv_address_line3 hr_locations.address_line_3%TYPE;
277: lv_town_or_city hr_locations.town_or_city%TYPE;
278: lv_postal_code hr_locations.postal_code%TYPE;
279: lv_country hr_locations.country%TYPE;
280: lv_state hr_locations.region_2%TYPE;
281: lv_maternal_last_name per_people_f.per_information1%TYPE;
282: lv_first_name per_people_f.first_name%TYPE;
283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;