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

Line 3096: FROM hr_locations hl,

3092: address_line_3, town_or_city,
3093: region_1, region_2,
3094: region_3, postal_code,
3095: country, telephone_number_1
3096: FROM hr_locations hl,
3097: hr_organization_units hou
3098: WHERE hou.organization_id = cp_organization_id
3099: AND hou.location_id = hl.location_id;
3100:

Line 3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;

3098: WHERE hou.organization_id = cp_organization_id
3099: AND hou.location_id = hl.location_id;
3100:
3101: lv_er_name hr_organization_units.name%TYPE;
3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;
3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;

Line 3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;

3099: AND hou.location_id = hl.location_id;
3100:
3101: lv_er_name hr_organization_units.name%TYPE;
3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;
3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;

Line 3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;

3100:
3101: lv_er_name hr_organization_units.name%TYPE;
3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;
3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;

Line 3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;

3101: lv_er_name hr_organization_units.name%TYPE;
3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;
3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;

Line 3106: lv_er_region_1 hr_locations.region_1%TYPE;

3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;
3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;
3110: lv_er_country hr_locations.country%TYPE;

Line 3107: lv_er_region_2 hr_locations.region_2%TYPE;

3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;
3110: lv_er_country hr_locations.country%TYPE;
3111: lv_er_telephone hr_locations.telephone_number_1%TYPE;

Line 3108: lv_er_region_3 hr_locations.region_3%TYPE;

3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;
3110: lv_er_country hr_locations.country%TYPE;
3111: lv_er_telephone hr_locations.telephone_number_1%TYPE;
3112:

Line 3109: lv_er_postal_code hr_locations.postal_code%TYPE;

3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;
3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;
3110: lv_er_country hr_locations.country%TYPE;
3111: lv_er_telephone hr_locations.telephone_number_1%TYPE;
3112:
3113: lv_is_er_exists VARCHAR2(1);

Line 3110: lv_er_country hr_locations.country%TYPE;

3106: lv_er_region_1 hr_locations.region_1%TYPE;
3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;
3110: lv_er_country hr_locations.country%TYPE;
3111: lv_er_telephone hr_locations.telephone_number_1%TYPE;
3112:
3113: lv_is_er_exists VARCHAR2(1);
3114: ln_index NUMBER;

Line 3111: lv_er_telephone hr_locations.telephone_number_1%TYPE;

3107: lv_er_region_2 hr_locations.region_2%TYPE;
3108: lv_er_region_3 hr_locations.region_3%TYPE;
3109: lv_er_postal_code hr_locations.postal_code%TYPE;
3110: lv_er_country hr_locations.country%TYPE;
3111: lv_er_telephone hr_locations.telephone_number_1%TYPE;
3112:
3113: lv_is_er_exists VARCHAR2(1);
3114: ln_index NUMBER;
3115: lv_procedure_name VARCHAR2(100);