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 237: FROM hr_locations_all hl

233: IS
234:
235: CURSOR csr_get_jd (cp_assignment_action_id NUMBER) IS
236: SELECT hl.region_1
237: FROM hr_locations_all hl
238: ,per_all_assignments_f paf
239: ,pay_assignment_actions paa
240: ,fnd_sessions fs
241: WHERE paa.assignment_action_id = cp_assignment_action_id

Line 583: FROM hr_locations location

579: SELECT location.address_line_1,
580: location.address_line_2, location.address_line_3,
581: location.town_or_city, location.postal_code,
582: location.country,location.region_2
583: FROM hr_locations location
584: WHERE location.location_id = p_location_id;
585:
586: CURSOR c_get_ee_information(p_asg_action_id number) IS
587: SELECT ppf.per_information1,

Line 638: lv_address_line1 hr_locations.address_line_1%TYPE;

634: ln_tax_unit_id number;
635: ln_bus_grp_id number;
636: lv_org_name hr_organization_units.name%TYPE;
637: ln_location_id hr_organization_units.location_id%TYPE;
638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;

Line 639: lv_address_line2 hr_locations.address_line_2%TYPE;

635: ln_bus_grp_id number;
636: lv_org_name hr_organization_units.name%TYPE;
637: ln_location_id hr_organization_units.location_id%TYPE;
638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;
643: lv_country hr_locations.country%TYPE;

Line 640: lv_address_line3 hr_locations.address_line_3%TYPE;

636: lv_org_name hr_organization_units.name%TYPE;
637: ln_location_id hr_organization_units.location_id%TYPE;
638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;
643: lv_country hr_locations.country%TYPE;
644: lv_state hr_locations.region_2%TYPE;

Line 641: lv_town_or_city hr_locations.town_or_city%TYPE;

637: ln_location_id hr_organization_units.location_id%TYPE;
638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;
643: lv_country hr_locations.country%TYPE;
644: lv_state hr_locations.region_2%TYPE;
645: lv_maternal_last_name per_people_f.per_information1%TYPE;

Line 642: lv_postal_code hr_locations.postal_code%TYPE;

638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;
643: lv_country hr_locations.country%TYPE;
644: lv_state hr_locations.region_2%TYPE;
645: lv_maternal_last_name per_people_f.per_information1%TYPE;
646: lv_first_name per_people_f.first_name%TYPE;

Line 643: lv_country hr_locations.country%TYPE;

639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;
643: lv_country hr_locations.country%TYPE;
644: lv_state hr_locations.region_2%TYPE;
645: lv_maternal_last_name per_people_f.per_information1%TYPE;
646: lv_first_name per_people_f.first_name%TYPE;
647: lv_last_name per_people_f.last_name%TYPE;

Line 644: lv_state hr_locations.region_2%TYPE;

640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;
642: lv_postal_code hr_locations.postal_code%TYPE;
643: lv_country hr_locations.country%TYPE;
644: lv_state hr_locations.region_2%TYPE;
645: lv_maternal_last_name per_people_f.per_information1%TYPE;
646: lv_first_name per_people_f.first_name%TYPE;
647: lv_last_name per_people_f.last_name%TYPE;
648: lv_middle_names per_people_f.middle_names%TYPE;