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

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

781: -- Access : Public --
782: -- Description : This function gets the gre location details --
783: -- --
784: -- Parameters : --
785: -- IN : p_location_id hr_locations.location_id --
786: -- : p_concatenate VARCHAR2 --
787: -- p_field VARCHAR2 --
788: --------------------------------------------------------------------------
789: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

Line 789: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

785: -- IN : p_location_id hr_locations.location_id --
786: -- : p_concatenate VARCHAR2 --
787: -- p_field VARCHAR2 --
788: --------------------------------------------------------------------------
789: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
790: ,p_rep_email_id IN VARCHAR2
791: ,p_rep_phone IN VARCHAR2
792: ,p_segment_num IN NUMBER
793: ,p_person_type IN VARCHAR2)

Line 807: FROM hr_locations

803: NVL(hr_general.decode_lookup('IN_STATE_CODES',loc_information16),'^'),
804: NVL(postal_code,'^'),
805: NVL(LOC_INFORMATION17,'^'),
806: NVL(TELEPHONE_NUMBER_1,'^')
807: FROM hr_locations
808: WHERE location_id = p_location_id;
809:
810: l_add_1 hr_locations.address_line_1%TYPE;
811: l_add_2 hr_locations.address_line_2%TYPE;

Line 810: l_add_1 hr_locations.address_line_1%TYPE;

806: NVL(TELEPHONE_NUMBER_1,'^')
807: FROM hr_locations
808: WHERE location_id = p_location_id;
809:
810: l_add_1 hr_locations.address_line_1%TYPE;
811: l_add_2 hr_locations.address_line_2%TYPE;
812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;

Line 811: l_add_2 hr_locations.address_line_2%TYPE;

807: FROM hr_locations
808: WHERE location_id = p_location_id;
809:
810: l_add_1 hr_locations.address_line_1%TYPE;
811: l_add_2 hr_locations.address_line_2%TYPE;
812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;

Line 812: l_add_3 hr_locations.address_line_3%TYPE;

808: WHERE location_id = p_location_id;
809:
810: l_add_1 hr_locations.address_line_1%TYPE;
811: l_add_2 hr_locations.address_line_2%TYPE;
812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;

Line 813: l_add_4 hr_locations.loc_information14%TYPE;

809:
810: l_add_1 hr_locations.address_line_1%TYPE;
811: l_add_2 hr_locations.address_line_2%TYPE;
812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;

Line 814: l_add_5 hr_locations.loc_information15%TYPE;

810: l_add_1 hr_locations.address_line_1%TYPE;
811: l_add_2 hr_locations.address_line_2%TYPE;
812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;
818: l_pin hr_locations.postal_code%TYPE;

Line 815: l_email hr_locations.loc_information17%TYPE;

811: l_add_2 hr_locations.address_line_2%TYPE;
812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;
818: l_pin hr_locations.postal_code%TYPE;
819: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;

Line 816: l_phone hr_locations.telephone_number_1%TYPE;

812: l_add_3 hr_locations.address_line_3%TYPE;
813: l_add_4 hr_locations.loc_information14%TYPE;
814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;
818: l_pin hr_locations.postal_code%TYPE;
819: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
820: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;

Line 818: l_pin hr_locations.postal_code%TYPE;

814: l_add_5 hr_locations.loc_information15%TYPE;
815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;
818: l_pin hr_locations.postal_code%TYPE;
819: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
820: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
821: l_remark VARCHAR2(75);
822: p_address1 VARCHAR2(60);

Line 819: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;

815: l_email hr_locations.loc_information17%TYPE;
816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;
818: l_pin hr_locations.postal_code%TYPE;
819: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
820: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
821: l_remark VARCHAR2(75);
822: p_address1 VARCHAR2(60);
823: p_address2 VARCHAR2(60);

Line 820: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;

816: l_phone hr_locations.telephone_number_1%TYPE;
817: l_state hr_lookups.meaning%TYPE;
818: l_pin hr_locations.postal_code%TYPE;
819: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
820: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
821: l_remark VARCHAR2(75);
822: p_address1 VARCHAR2(60);
823: p_address2 VARCHAR2(60);
824: p_address3 VARCHAR2(60);