APPS.JTF_RS_RES_SSWA_PUB dependencies on HR_LOCATIONS

Line 99: from hr_locations

95: address_line_3 ,
96: town_or_city ,
97: country,
98: postal_code
99: from hr_locations
100: where location_id = l_address_id;
101:
102: l_address_line_1 hr_locations.address_line_1%type;
103: l_address_line_2 hr_locations.address_line_2%type;

Line 102: l_address_line_1 hr_locations.address_line_1%type;

98: postal_code
99: from hr_locations
100: where location_id = l_address_id;
101:
102: l_address_line_1 hr_locations.address_line_1%type;
103: l_address_line_2 hr_locations.address_line_2%type;
104: l_address_line_3 hr_locations.address_line_3%type;
105: l_town_or_city hr_locations.town_or_city%type;
106: l_country hr_locations.country%type;

Line 103: l_address_line_2 hr_locations.address_line_2%type;

99: from hr_locations
100: where location_id = l_address_id;
101:
102: l_address_line_1 hr_locations.address_line_1%type;
103: l_address_line_2 hr_locations.address_line_2%type;
104: l_address_line_3 hr_locations.address_line_3%type;
105: l_town_or_city hr_locations.town_or_city%type;
106: l_country hr_locations.country%type;
107: l_postal_code hr_locations.postal_code%type;

Line 104: l_address_line_3 hr_locations.address_line_3%type;

100: where location_id = l_address_id;
101:
102: l_address_line_1 hr_locations.address_line_1%type;
103: l_address_line_2 hr_locations.address_line_2%type;
104: l_address_line_3 hr_locations.address_line_3%type;
105: l_town_or_city hr_locations.town_or_city%type;
106: l_country hr_locations.country%type;
107: l_postal_code hr_locations.postal_code%type;
108: -- address_rec address_cur%rowtype;

Line 105: l_town_or_city hr_locations.town_or_city%type;

101:
102: l_address_line_1 hr_locations.address_line_1%type;
103: l_address_line_2 hr_locations.address_line_2%type;
104: l_address_line_3 hr_locations.address_line_3%type;
105: l_town_or_city hr_locations.town_or_city%type;
106: l_country hr_locations.country%type;
107: l_postal_code hr_locations.postal_code%type;
108: -- address_rec address_cur%rowtype;
109:

Line 106: l_country hr_locations.country%type;

102: l_address_line_1 hr_locations.address_line_1%type;
103: l_address_line_2 hr_locations.address_line_2%type;
104: l_address_line_3 hr_locations.address_line_3%type;
105: l_town_or_city hr_locations.town_or_city%type;
106: l_country hr_locations.country%type;
107: l_postal_code hr_locations.postal_code%type;
108: -- address_rec address_cur%rowtype;
109:
110: /* Cursor Variables to get Org Deatils */

Line 107: l_postal_code hr_locations.postal_code%type;

103: l_address_line_2 hr_locations.address_line_2%type;
104: l_address_line_3 hr_locations.address_line_3%type;
105: l_town_or_city hr_locations.town_or_city%type;
106: l_country hr_locations.country%type;
107: l_postal_code hr_locations.postal_code%type;
108: -- address_rec address_cur%rowtype;
109:
110: /* Cursor Variables to get Org Deatils */
111:

Line 825: from hr_locations

821: ADDRESS_LINE_3 ,
822: TOWN_OR_CITY ,
823: COUNTRY,
824: POSTAL_CODE
825: from hr_locations
826: where location_id = l_address_id;
827:
828: address_rec address_cur%rowtype;
829: