APPS.PAY_IE_BIK dependencies on PER_ADDRESSES

Line 271: from per_addresses

267: begin
268: hr_utility.set_location('Entering ' || l_proc, 20);
269: if l_address_type='address_line1' then
270: open l_address_refcur for select address_line1
271: from per_addresses
272: where address_id=l_address_id;
273: elsif l_address_type='address_line2' then
274: open l_address_refcur for select address_line2
275: from per_addresses

Line 275: from per_addresses

271: from per_addresses
272: where address_id=l_address_id;
273: elsif l_address_type='address_line2' then
274: open l_address_refcur for select address_line2
275: from per_addresses
276: where address_id=l_address_id;
277: elsif l_address_type='address_line3' then
278: open l_address_refcur for select address_line3
279: from per_addresses

Line 279: from per_addresses

275: from per_addresses
276: where address_id=l_address_id;
277: elsif l_address_type='address_line3' then
278: open l_address_refcur for select address_line3
279: from per_addresses
280: where address_id=l_address_id;
281: elsif l_address_type= 'town_or_city' then
282: open l_address_refcur for select town_or_city
283: from per_addresses

Line 283: from per_addresses

279: from per_addresses
280: where address_id=l_address_id;
281: elsif l_address_type= 'town_or_city' then
282: open l_address_refcur for select town_or_city
283: from per_addresses
284: where address_id=l_address_id;
285: elsif l_address_type= 'region_1' then
286: open l_address_refcur for select region_1
287: from per_addresses

Line 287: from per_addresses

283: from per_addresses
284: where address_id=l_address_id;
285: elsif l_address_type= 'region_1' then
286: open l_address_refcur for select region_1
287: from per_addresses
288: where address_id=l_address_id;
289: elsif l_address_type= 'postal_code' then
290: open l_address_refcur for select postal_code
291: from per_addresses

Line 291: from per_addresses

287: from per_addresses
288: where address_id=l_address_id;
289: elsif l_address_type= 'postal_code' then
290: open l_address_refcur for select postal_code
291: from per_addresses
292: where address_id=l_address_id;
293: elsif l_address_type= 'country' then
294: open l_address_refcur for select country
295: from per_addresses

Line 295: from per_addresses

291: from per_addresses
292: where address_id=l_address_id;
293: elsif l_address_type= 'country' then
294: open l_address_refcur for select country
295: from per_addresses
296: where address_id=l_address_id;
297: end if;
298:
299: fetch l_address_refcur into l_address;