APPS.PAY_IN_EOY_ER_RETURNS dependencies on HR_LOCATIONS

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

572: -- Access : Public --
573: -- Description : This function gets the gre location details --
574: -- --
575: -- Parameters : --
576: -- IN : p_location_id hr_locations.location_id --
577: -- : p_concatenate VARCHAR2 --
578: -- p_field VARCHAR2 --
579: --------------------------------------------------------------------------
580: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE)

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

576: -- IN : p_location_id hr_locations.location_id --
577: -- : p_concatenate VARCHAR2 --
578: -- p_field VARCHAR2 --
579: --------------------------------------------------------------------------
580: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE)
581: RETURN VARCHAR2
582: IS
583:
584: CURSOR csr_add IS

Line 592: FROM hr_locations

588: NVL(loc_information14,' '),
589: loc_information15,
590: NVL(hr_general.decode_lookup('IN_STATE_CODES',loc_information16),' '),
591: NVL(postal_code,' ')
592: FROM hr_locations
593: WHERE location_id = p_location_id;
594:
595: l_add_1 hr_locations.address_line_1%TYPE;
596: l_add_2 hr_locations.address_line_2%TYPE;

Line 595: l_add_1 hr_locations.address_line_1%TYPE;

591: NVL(postal_code,' ')
592: FROM hr_locations
593: WHERE location_id = p_location_id;
594:
595: l_add_1 hr_locations.address_line_1%TYPE;
596: l_add_2 hr_locations.address_line_2%TYPE;
597: l_add_3 hr_locations.address_line_3%TYPE;
598: l_add_4 hr_locations.loc_information14%TYPE;
599: l_add_5 hr_locations.loc_information15%TYPE;

Line 596: l_add_2 hr_locations.address_line_2%TYPE;

592: FROM hr_locations
593: WHERE location_id = p_location_id;
594:
595: l_add_1 hr_locations.address_line_1%TYPE;
596: l_add_2 hr_locations.address_line_2%TYPE;
597: l_add_3 hr_locations.address_line_3%TYPE;
598: l_add_4 hr_locations.loc_information14%TYPE;
599: l_add_5 hr_locations.loc_information15%TYPE;
600: l_state hr_lookups.meaning%TYPE;

Line 597: l_add_3 hr_locations.address_line_3%TYPE;

593: WHERE location_id = p_location_id;
594:
595: l_add_1 hr_locations.address_line_1%TYPE;
596: l_add_2 hr_locations.address_line_2%TYPE;
597: l_add_3 hr_locations.address_line_3%TYPE;
598: l_add_4 hr_locations.loc_information14%TYPE;
599: l_add_5 hr_locations.loc_information15%TYPE;
600: l_state hr_lookups.meaning%TYPE;
601: l_pin hr_locations.postal_code%TYPE;

Line 598: l_add_4 hr_locations.loc_information14%TYPE;

594:
595: l_add_1 hr_locations.address_line_1%TYPE;
596: l_add_2 hr_locations.address_line_2%TYPE;
597: l_add_3 hr_locations.address_line_3%TYPE;
598: l_add_4 hr_locations.loc_information14%TYPE;
599: l_add_5 hr_locations.loc_information15%TYPE;
600: l_state hr_lookups.meaning%TYPE;
601: l_pin hr_locations.postal_code%TYPE;
602: p_address VARCHAR2(200);

Line 599: l_add_5 hr_locations.loc_information15%TYPE;

595: l_add_1 hr_locations.address_line_1%TYPE;
596: l_add_2 hr_locations.address_line_2%TYPE;
597: l_add_3 hr_locations.address_line_3%TYPE;
598: l_add_4 hr_locations.loc_information14%TYPE;
599: l_add_5 hr_locations.loc_information15%TYPE;
600: l_state hr_lookups.meaning%TYPE;
601: l_pin hr_locations.postal_code%TYPE;
602: p_address VARCHAR2(200);
603: --

Line 601: l_pin hr_locations.postal_code%TYPE;

597: l_add_3 hr_locations.address_line_3%TYPE;
598: l_add_4 hr_locations.loc_information14%TYPE;
599: l_add_5 hr_locations.loc_information15%TYPE;
600: l_state hr_lookups.meaning%TYPE;
601: l_pin hr_locations.postal_code%TYPE;
602: p_address VARCHAR2(200);
603: --
604: l_procedure varchar2(100);
605: