APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_UNIT_VER_ALL

Line 142: CURSOR c_unit_ver(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

138: ORDER BY unit_cd,version_number;
139:
140: -- Unit Version Interface Table cursor
141:
142: CURSOR c_unit_ver(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
143: SELECT *
144: FROM igs_ps_lgcy_uv_int
145: WHERE batch_id=p_n_batch_id
146: AND unit_cd=cp_c_unit_cd

Line 152: CURSOR c_teach_resp(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

148: AND import_status IN ('U','R');
149:
150: -- Teaching Responsibility Interface Table cursor
151:
152: CURSOR c_teach_resp(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
153: SELECT *
154: FROM igs_ps_lgcy_tr_int
155: WHERE batch_id=p_n_batch_id
156: AND unit_cd=cp_c_unit_cd

Line 163: CURSOR c_unit_disp(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

159: ORDER BY unit_cd,version_number, teach_resp_int_id;
160:
161: -- Unit Discplines Interface Table cursor
162:
163: CURSOR c_unit_disp(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
164: SELECT *
165: FROM igs_ps_lgcy_ud_int
166: WHERE batch_id=p_n_batch_id
167: AND unit_cd=cp_c_unit_cd

Line 175: CURSOR c_grd_sch(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

171:
172:
173: -- Grading Schema Interface Table cursor
174:
175: CURSOR c_grd_sch(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
176: SELECT *
177: FROM igs_ps_lgcy_ug_int
178: WHERE batch_id=p_n_batch_id
179: AND unit_cd=cp_c_unit_cd

Line 186: CURSOR c_unit_sec(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

182: ORDER BY unit_cd,unit_version_number, uv_grd_schm_int_id;
183:
184: -- Unit Section Interface Table cursor
185:
186: CURSOR c_unit_sec(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
187: SELECT *
188: FROM igs_ps_lgcy_us_int
189: WHERE batch_id=p_n_batch_id
190: AND unit_cd=cp_c_unit_cd

Line 197: CURSOR c_us_grd_sch(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

193: ORDER BY unit_cd,version_number, unit_section_int_id;
194:
195: -- Unit Section Grading Schema Interface Table cursor
196:
197: CURSOR c_us_grd_sch(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
198: SELECT *
199: FROM igs_ps_lgcy_sg_int
200: WHERE batch_id=p_n_batch_id
201: AND unit_cd=cp_c_unit_cd

Line 208: CURSOR c_uso(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

204: ORDER BY unit_cd,version_number, usec_grd_schm_int_id;
205:
206: -- Unit Section Occurrences Interface Table cursor
207:
208: CURSOR c_uso(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
209: SELECT *
210: FROM igs_ps_lgcy_oc_int
211: WHERE batch_id=p_n_batch_id
212: AND unit_cd=cp_c_unit_cd

Line 219: CURSOR c_unit_ref_cd(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS

215: ORDER BY unit_cd,version_number, usec_occur_int_id;
216:
217: -- Unit Reference Codes Interface Table cursor
218:
219: CURSOR c_unit_ref_cd(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
220: SELECT *
221: FROM igs_ps_lgcy_ur_int
222: WHERE batch_id=p_n_batch_id
223: AND unit_cd=cp_c_unit_cd