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

Line 948: -- IN : p_location_id hr_locations.location_id --

944: -- Access : Private --
945: -- Description : This function gets the gre location details --
946: -- --
947: -- Parameters : --
948: -- IN : p_location_id hr_locations.location_id --
949: -- : p_concatenate VARCHAR2 --
950: -- p_field VARCHAR2 --
951: --------------------------------------------------------------------------
952: FUNCTION get_location_details ( p_location_id IN VARCHAR2

Line 967: FROM hr_locations

963: hr_general.decode_lookup('IN_STATES',loc_information16),
964: postal_code,
965: telephone_number_1,
966: telephone_number_2
967: FROM hr_locations
968: WHERE location_id = p_location_id;
969:
970: l_add_1 hr_locations.address_line_1%TYPE;
971: l_add_2 hr_locations.address_line_2%TYPE;

Line 970: l_add_1 hr_locations.address_line_1%TYPE;

966: telephone_number_2
967: FROM hr_locations
968: WHERE location_id = p_location_id;
969:
970: l_add_1 hr_locations.address_line_1%TYPE;
971: l_add_2 hr_locations.address_line_2%TYPE;
972: l_add_3 hr_locations.address_line_3%TYPE;
973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;

Line 971: l_add_2 hr_locations.address_line_2%TYPE;

967: FROM hr_locations
968: WHERE location_id = p_location_id;
969:
970: l_add_1 hr_locations.address_line_1%TYPE;
971: l_add_2 hr_locations.address_line_2%TYPE;
972: l_add_3 hr_locations.address_line_3%TYPE;
973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;

Line 972: l_add_3 hr_locations.address_line_3%TYPE;

968: WHERE location_id = p_location_id;
969:
970: l_add_1 hr_locations.address_line_1%TYPE;
971: l_add_2 hr_locations.address_line_2%TYPE;
972: l_add_3 hr_locations.address_line_3%TYPE;
973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;
976: l_pin hr_locations.postal_code%TYPE;

Line 973: l_add_4 hr_locations.loc_information14%TYPE;

969:
970: l_add_1 hr_locations.address_line_1%TYPE;
971: l_add_2 hr_locations.address_line_2%TYPE;
972: l_add_3 hr_locations.address_line_3%TYPE;
973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;
976: l_pin hr_locations.postal_code%TYPE;
977: l_tel hr_locations.telephone_number_1%TYPE;

Line 974: l_add_5 hr_locations.loc_information15%TYPE;

970: l_add_1 hr_locations.address_line_1%TYPE;
971: l_add_2 hr_locations.address_line_2%TYPE;
972: l_add_3 hr_locations.address_line_3%TYPE;
973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;
976: l_pin hr_locations.postal_code%TYPE;
977: l_tel hr_locations.telephone_number_1%TYPE;
978: l_fax hr_locations.telephone_number_2%TYPE;

Line 976: l_pin hr_locations.postal_code%TYPE;

972: l_add_3 hr_locations.address_line_3%TYPE;
973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;
976: l_pin hr_locations.postal_code%TYPE;
977: l_tel hr_locations.telephone_number_1%TYPE;
978: l_fax hr_locations.telephone_number_2%TYPE;
979: l_details VARCHAR2(1000);
980: l_message VARCHAR2(255);

Line 977: l_tel hr_locations.telephone_number_1%TYPE;

973: l_add_4 hr_locations.loc_information14%TYPE;
974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;
976: l_pin hr_locations.postal_code%TYPE;
977: l_tel hr_locations.telephone_number_1%TYPE;
978: l_fax hr_locations.telephone_number_2%TYPE;
979: l_details VARCHAR2(1000);
980: l_message VARCHAR2(255);
981: l_procedure VARCHAR2(100);

Line 978: l_fax hr_locations.telephone_number_2%TYPE;

974: l_add_5 hr_locations.loc_information15%TYPE;
975: l_state hr_lookups.meaning%TYPE;
976: l_pin hr_locations.postal_code%TYPE;
977: l_tel hr_locations.telephone_number_1%TYPE;
978: l_fax hr_locations.telephone_number_2%TYPE;
979: l_details VARCHAR2(1000);
980: l_message VARCHAR2(255);
981: l_procedure VARCHAR2(100);
982: