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

Line 218: FROM hr_locations_all hl

214: IS
215:
216: CURSOR csr_get_jd (cp_assignment_action_id NUMBER) IS
217: SELECT hl.region_1
218: FROM hr_locations_all hl
219: ,per_all_assignments_f paf
220: ,pay_assignment_actions paa
221: ,fnd_sessions fs
222: WHERE paa.assignment_action_id = cp_assignment_action_id

Line 564: FROM hr_locations location

560: SELECT location.address_line_1,
561: location.address_line_2, location.address_line_3,
562: location.town_or_city, location.postal_code,
563: location.country,location.region_2
564: FROM hr_locations location
565: WHERE location.location_id = p_location_id;
566:
567: CURSOR c_get_ee_information(p_asg_action_id number) IS
568: SELECT ppf.per_information1,

Line 619: lv_address_line1 hr_locations.address_line_1%TYPE;

615: ln_tax_unit_id number;
616: ln_bus_grp_id number;
617: lv_org_name hr_organization_units.name%TYPE;
618: ln_location_id hr_organization_units.location_id%TYPE;
619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;

Line 620: lv_address_line2 hr_locations.address_line_2%TYPE;

616: ln_bus_grp_id number;
617: lv_org_name hr_organization_units.name%TYPE;
618: ln_location_id hr_organization_units.location_id%TYPE;
619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;
624: lv_country hr_locations.country%TYPE;

Line 621: lv_address_line3 hr_locations.address_line_3%TYPE;

617: lv_org_name hr_organization_units.name%TYPE;
618: ln_location_id hr_organization_units.location_id%TYPE;
619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;
624: lv_country hr_locations.country%TYPE;
625: lv_state hr_locations.region_2%TYPE;

Line 622: lv_town_or_city hr_locations.town_or_city%TYPE;

618: ln_location_id hr_organization_units.location_id%TYPE;
619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;
624: lv_country hr_locations.country%TYPE;
625: lv_state hr_locations.region_2%TYPE;
626: lv_maternal_last_name per_people_f.per_information1%TYPE;

Line 623: lv_postal_code hr_locations.postal_code%TYPE;

619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;
624: lv_country hr_locations.country%TYPE;
625: lv_state hr_locations.region_2%TYPE;
626: lv_maternal_last_name per_people_f.per_information1%TYPE;
627: lv_first_name per_people_f.first_name%TYPE;

Line 624: lv_country hr_locations.country%TYPE;

620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;
624: lv_country hr_locations.country%TYPE;
625: lv_state hr_locations.region_2%TYPE;
626: lv_maternal_last_name per_people_f.per_information1%TYPE;
627: lv_first_name per_people_f.first_name%TYPE;
628: lv_last_name per_people_f.last_name%TYPE;

Line 625: lv_state hr_locations.region_2%TYPE;

621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;
623: lv_postal_code hr_locations.postal_code%TYPE;
624: lv_country hr_locations.country%TYPE;
625: lv_state hr_locations.region_2%TYPE;
626: lv_maternal_last_name per_people_f.per_information1%TYPE;
627: lv_first_name per_people_f.first_name%TYPE;
628: lv_last_name per_people_f.last_name%TYPE;
629: lv_middle_names per_people_f.middle_names%TYPE;