APPS.PAY_PAYUSNAC_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 52: address_line_1 hr_locations_all.address_line_1%TYPE;

48:
49: function get_address(loc_id in number) return varchar2 is
50: f_address varchar2(300) := null;
51:
52: address_line_1 hr_locations_all.address_line_1%TYPE;
53: address_line_2 hr_locations_all.address_line_2%TYPE;
54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;

Line 53: address_line_2 hr_locations_all.address_line_2%TYPE;

49: function get_address(loc_id in number) return varchar2 is
50: f_address varchar2(300) := null;
51:
52: address_line_1 hr_locations_all.address_line_1%TYPE;
53: address_line_2 hr_locations_all.address_line_2%TYPE;
54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;
57: postal_code hr_locations_all.postal_code%TYPE;

Line 54: address_line_3 hr_locations_all.address_line_3%TYPE;

50: f_address varchar2(300) := null;
51:
52: address_line_1 hr_locations_all.address_line_1%TYPE;
53: address_line_2 hr_locations_all.address_line_2%TYPE;
54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;
57: postal_code hr_locations_all.postal_code%TYPE;
58: region_2 hr_locations_all.region_2%type;

Line 55: location_code hr_locations_all.location_code%type;

51:
52: address_line_1 hr_locations_all.address_line_1%TYPE;
53: address_line_2 hr_locations_all.address_line_2%TYPE;
54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;
57: postal_code hr_locations_all.postal_code%TYPE;
58: region_2 hr_locations_all.region_2%type;
59:

Line 56: town_or_city hr_locations_all.town_or_city%TYPE;

52: address_line_1 hr_locations_all.address_line_1%TYPE;
53: address_line_2 hr_locations_all.address_line_2%TYPE;
54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;
57: postal_code hr_locations_all.postal_code%TYPE;
58: region_2 hr_locations_all.region_2%type;
59:
60: cursor get_loc_rec is

Line 57: postal_code hr_locations_all.postal_code%TYPE;

53: address_line_2 hr_locations_all.address_line_2%TYPE;
54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;
57: postal_code hr_locations_all.postal_code%TYPE;
58: region_2 hr_locations_all.region_2%type;
59:
60: cursor get_loc_rec is
61: select address_line_1,

Line 58: region_2 hr_locations_all.region_2%type;

54: address_line_3 hr_locations_all.address_line_3%TYPE;
55: location_code hr_locations_all.location_code%type;
56: town_or_city hr_locations_all.town_or_city%TYPE;
57: postal_code hr_locations_all.postal_code%TYPE;
58: region_2 hr_locations_all.region_2%type;
59:
60: cursor get_loc_rec is
61: select address_line_1,
62: address_line_2,

Line 68: from hr_locations_all

64: town_or_city,
65: region_2,
66: postal_code,
67: location_code
68: from hr_locations_all
69: where location_id = loc_id;
70: begin
71: open get_loc_rec;
72: fetch get_loc_rec into address_line_1,