APPS.IGS_AD_IMP_015 dependencies on IGS_PE_SRC_TYPES_ALL

Line 128: l_system_source_type igs_pe_src_types_all.system_source_type%TYPE;

124: l_schema VARCHAR2(30);
125:
126: l_meaning igs_lookup_values.meaning%TYPE;
127: l_stmt VARCHAR2(2000);
128: l_system_source_type igs_pe_src_types_all.system_source_type%TYPE;
129:
130: CURSOR c_system_source_type IS
131: SELECT system_source_type
132: FROM igs_pe_src_types_all

Line 132: FROM igs_pe_src_types_all

128: l_system_source_type igs_pe_src_types_all.system_source_type%TYPE;
129:
130: CURSOR c_system_source_type IS
131: SELECT system_source_type
132: FROM igs_pe_src_types_all
133: WHERE source_type_id = p_source_type_id
134: AND NVL(closed_ind,'N') = 'N';
135:
136: BEGIN