430: oadv.addr_line_2 oadv_addr_line_2,
431: oadv.addr_line_3 oadv_addr_line_3,
432: oadv.addr_line_4 oadv_addr_line_4,
433: oadv.city oadv_city
434: FROM IGS_OR_ADDR oadv
435: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
436: oadv.correspondence_ind = 'Y';
437:
438: -- cursor for selection of the IGS_OR_UNIT address when
446: oadv.addr_line_2 oadv_addr_line_2,
447: oadv.addr_line_3 oadv_addr_line_3,
448: oadv.addr_line_4 oadv_addr_line_4,
449: oadv.city oadv_city
450: FROM IGS_OR_ADDR oadv
451: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
452: oadv.addr_type = cp_addr_type;
453:
454: -- Local Variables