APPS.PAY_IE_BIK dependencies on HR_LOCATIONS

Line 331: hr_locations hl

327: if l_address_type='address_line1' then
328:
329: open l_landlord_refcur for select hl.ADDRESS_LINE_1
330: from hr_all_organization_units hou,
331: hr_locations hl
332: where hou.organization_id=l_address_id
333: and hou.location_id=hl.location_id;
334:
335: elsif l_address_type='address_line2' then

Line 339: hr_locations hl

335: elsif l_address_type='address_line2' then
336:
337: open l_landlord_refcur for select hl.ADDRESS_LINE_2
338: from hr_all_organization_units hou,
339: hr_locations hl
340: where hou.organization_id=l_address_id
341: and hou.location_id=hl.location_id;
342:
343: elsif l_address_type='address_line3' then

Line 346: from hr_all_organization_units hou,hr_locations hl

342:
343: elsif l_address_type='address_line3' then
344:
345: open l_landlord_refcur for select hl.ADDRESS_LINE_3
346: from hr_all_organization_units hou,hr_locations hl
347: where hou.organization_id=l_address_id
348: and hou.location_id=hl.location_id;
349:
350: elsif l_address_type= 'town_or_city' then

Line 353: from hr_all_organization_units hou,hr_locations hl

349:
350: elsif l_address_type= 'town_or_city' then
351:
352: open l_landlord_refcur for select hl.town_or_city
353: from hr_all_organization_units hou,hr_locations hl
354: where hou.organization_id=l_address_id
355: and hou.location_id=hl.location_id;
356:
357: elsif l_address_type= 'region_1' then

Line 360: from hr_all_organization_units hou,hr_locations hl

356:
357: elsif l_address_type= 'region_1' then
358:
359: open l_landlord_refcur for select hl.region_1
360: from hr_all_organization_units hou,hr_locations hl
361: where hou.organization_id=l_address_id
362: and hou.location_id=hl.location_id;
363:
364: elsif l_address_type= 'postal_code' then

Line 367: from hr_all_organization_units hou,hr_locations hl

363:
364: elsif l_address_type= 'postal_code' then
365:
366: open l_landlord_refcur for select hl.postal_code
367: from hr_all_organization_units hou,hr_locations hl
368: where hou.organization_id=l_address_id
369: and hou.location_id=hl.location_id;
370:
371: elsif l_address_type= 'country' then

Line 374: from hr_all_organization_units hou,hr_locations hl

370:
371: elsif l_address_type= 'country' then
372:
373: open l_landlord_refcur for select hl.country
374: from hr_all_organization_units hou,hr_locations hl
375: where hou.organization_id=l_address_id
376: and hou.location_id=hl.location_id;
377: end if;
378: fetch l_landlord_refcur into l_landlord;