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 1028: -- IN : p_location_id hr_locations.location_id --

1024: -- Access : Private --
1025: -- Description : This function gets the gre location details --
1026: -- --
1027: -- Parameters : --
1028: -- IN : p_location_id hr_locations.location_id --
1029: -- : p_concatenate VARCHAR2 --
1030: -- p_field VARCHAR2 --
1031: --------------------------------------------------------------------------
1032: FUNCTION get_location_details ( p_location_id IN VARCHAR2

Line 1047: FROM hr_locations

1043: hr_general.decode_lookup('IN_STATES',loc_information16),
1044: postal_code,
1045: telephone_number_1,
1046: telephone_number_2
1047: FROM hr_locations
1048: WHERE location_id = p_location_id;
1049:
1050: l_add_1 hr_locations.address_line_1%TYPE;
1051: l_add_2 hr_locations.address_line_2%TYPE;

Line 1050: l_add_1 hr_locations.address_line_1%TYPE;

1046: telephone_number_2
1047: FROM hr_locations
1048: WHERE location_id = p_location_id;
1049:
1050: l_add_1 hr_locations.address_line_1%TYPE;
1051: l_add_2 hr_locations.address_line_2%TYPE;
1052: l_add_3 hr_locations.address_line_3%TYPE;
1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;

Line 1051: l_add_2 hr_locations.address_line_2%TYPE;

1047: FROM hr_locations
1048: WHERE location_id = p_location_id;
1049:
1050: l_add_1 hr_locations.address_line_1%TYPE;
1051: l_add_2 hr_locations.address_line_2%TYPE;
1052: l_add_3 hr_locations.address_line_3%TYPE;
1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;

Line 1052: l_add_3 hr_locations.address_line_3%TYPE;

1048: WHERE location_id = p_location_id;
1049:
1050: l_add_1 hr_locations.address_line_1%TYPE;
1051: l_add_2 hr_locations.address_line_2%TYPE;
1052: l_add_3 hr_locations.address_line_3%TYPE;
1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;
1056: l_pin hr_locations.postal_code%TYPE;

Line 1053: l_add_4 hr_locations.loc_information14%TYPE;

1049:
1050: l_add_1 hr_locations.address_line_1%TYPE;
1051: l_add_2 hr_locations.address_line_2%TYPE;
1052: l_add_3 hr_locations.address_line_3%TYPE;
1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;
1056: l_pin hr_locations.postal_code%TYPE;
1057: l_tel hr_locations.telephone_number_1%TYPE;

Line 1054: l_add_5 hr_locations.loc_information15%TYPE;

1050: l_add_1 hr_locations.address_line_1%TYPE;
1051: l_add_2 hr_locations.address_line_2%TYPE;
1052: l_add_3 hr_locations.address_line_3%TYPE;
1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;
1056: l_pin hr_locations.postal_code%TYPE;
1057: l_tel hr_locations.telephone_number_1%TYPE;
1058: l_fax hr_locations.telephone_number_2%TYPE;

Line 1056: l_pin hr_locations.postal_code%TYPE;

1052: l_add_3 hr_locations.address_line_3%TYPE;
1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;
1056: l_pin hr_locations.postal_code%TYPE;
1057: l_tel hr_locations.telephone_number_1%TYPE;
1058: l_fax hr_locations.telephone_number_2%TYPE;
1059: l_details VARCHAR2(1000);
1060: l_message VARCHAR2(255);

Line 1057: l_tel hr_locations.telephone_number_1%TYPE;

1053: l_add_4 hr_locations.loc_information14%TYPE;
1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;
1056: l_pin hr_locations.postal_code%TYPE;
1057: l_tel hr_locations.telephone_number_1%TYPE;
1058: l_fax hr_locations.telephone_number_2%TYPE;
1059: l_details VARCHAR2(1000);
1060: l_message VARCHAR2(255);
1061: l_procedure VARCHAR2(100);

Line 1058: l_fax hr_locations.telephone_number_2%TYPE;

1054: l_add_5 hr_locations.loc_information15%TYPE;
1055: l_state hr_lookups.meaning%TYPE;
1056: l_pin hr_locations.postal_code%TYPE;
1057: l_tel hr_locations.telephone_number_1%TYPE;
1058: l_fax hr_locations.telephone_number_2%TYPE;
1059: l_details VARCHAR2(1000);
1060: l_message VARCHAR2(255);
1061: l_procedure VARCHAR2(100);
1062: