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

Line 336: l_location_address1 hr_locations.address_line_1%TYPE;

332: FROM per_addresses pad
333: WHERE pad.address_id = p_address_id;
334:
335: l_procedure VARCHAR2(100);
336: l_location_address1 hr_locations.address_line_1%TYPE;
337: l_location_address2 hr_locations.address_line_2%TYPE;
338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;

Line 337: l_location_address2 hr_locations.address_line_2%TYPE;

333: WHERE pad.address_id = p_address_id;
334:
335: l_procedure VARCHAR2(100);
336: l_location_address1 hr_locations.address_line_1%TYPE;
337: l_location_address2 hr_locations.address_line_2%TYPE;
338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;

Line 338: l_location_address3 hr_locations.address_line_3%TYPE;

334:
335: l_procedure VARCHAR2(100);
336: l_location_address1 hr_locations.address_line_1%TYPE;
337: l_location_address2 hr_locations.address_line_2%TYPE;
338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;
342: l_location_country hr_locations.country%TYPE;

Line 339: l_location_address4 hr_locations.loc_information14%TYPE;

335: l_procedure VARCHAR2(100);
336: l_location_address1 hr_locations.address_line_1%TYPE;
337: l_location_address2 hr_locations.address_line_2%TYPE;
338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;
342: l_location_country hr_locations.country%TYPE;
343: l_location_zipcode hr_locations.postal_code%TYPE;

Line 340: l_location_city hr_locations.loc_information15%TYPE;

336: l_location_address1 hr_locations.address_line_1%TYPE;
337: l_location_address2 hr_locations.address_line_2%TYPE;
338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;
342: l_location_country hr_locations.country%TYPE;
343: l_location_zipcode hr_locations.postal_code%TYPE;
344: l_details VARCHAR2(1000);

Line 341: l_location_state hr_locations.loc_information16%TYPE;

337: l_location_address2 hr_locations.address_line_2%TYPE;
338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;
342: l_location_country hr_locations.country%TYPE;
343: l_location_zipcode hr_locations.postal_code%TYPE;
344: l_details VARCHAR2(1000);
345:

Line 342: l_location_country hr_locations.country%TYPE;

338: l_location_address3 hr_locations.address_line_3%TYPE;
339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;
342: l_location_country hr_locations.country%TYPE;
343: l_location_zipcode hr_locations.postal_code%TYPE;
344: l_details VARCHAR2(1000);
345:
346: BEGIN

Line 343: l_location_zipcode hr_locations.postal_code%TYPE;

339: l_location_address4 hr_locations.loc_information14%TYPE;
340: l_location_city hr_locations.loc_information15%TYPE;
341: l_location_state hr_locations.loc_information16%TYPE;
342: l_location_country hr_locations.country%TYPE;
343: l_location_zipcode hr_locations.postal_code%TYPE;
344: l_details VARCHAR2(1000);
345:
346: BEGIN
347: g_debug := hr_utility.debug_enabled;