APPS.IGS_GE_GEN_004 dependencies on IGS_CO_ADDR_TYPE

Line 144: CURSOR c_adt( cp_addr_type IGS_CO_ADDR_TYPE.addr_type%TYPE,

140: -- and correspondence indicator exists in the system. This is
141: -- only used for validation in the Inquiry System.
142: v_other_detail VARCHAR2(255) := NULL;
143: v_found VARCHAR2(1) := NULL;
144: CURSOR c_adt( cp_addr_type IGS_CO_ADDR_TYPE.addr_type%TYPE,
145: cp_crsp_ind IGS_PE_PERSON_ADDR.correspondence_ind%TYPE)
146: iS
147: SELECT
148: 'x'

Line 149: FROM IGS_CO_ADDR_TYPE adt

145: cp_crsp_ind IGS_PE_PERSON_ADDR.correspondence_ind%TYPE)
146: iS
147: SELECT
148: 'x'
149: FROM IGS_CO_ADDR_TYPE adt
150: WHERE adt.addr_type = cp_addr_type;
151:
152: BEGIN
153: IF c_adt%ISOPEN