APPS.IGS_GE_GEN_001 dependencies on IGS_OR_INST_ADDR

Line 828: FROM IGS_OR_INST_ADDR iadv

824: iadv.addr_line_2 iadv_addr_line_2,
825: iadv.addr_line_3 iadv_addr_line_3,
826: iadv.addr_line_4 iadv_addr_line_4,
827: iadv.city iadv_city
828: FROM IGS_OR_INST_ADDR iadv
829: WHERE iadv.institution_cd = cp_institution_cd AND
830: iadv.correspondence_ind = 'Y';
831: -- cursor for selection of the IGS_OR_INSTITUTION address when
832: -- only the institution_cd and IGS_CO_ADDR_TYPE is supplied

Line 843: FROM IGS_OR_INST_ADDR iadv

839: iadv.addr_line_2 iadv_addr_line_2,
840: iadv.addr_line_3 iadv_addr_line_3,
841: iadv.addr_line_4 iadv_addr_line_4,
842: iadv.city iadv_city
843: FROM IGS_OR_INST_ADDR iadv
844: WHERE iadv.institution_cd = cp_institution_cd AND
845: iadv.addr_type = cp_addr_type;
846: -- Local Variables
847: v_name VARCHAR2(256) := NULL;