APPS.IGS_AD_IMP_027 dependencies on IGS_AD_APPL_HIST

Line 166: FROM igs_ad_appl_hist

162: , status ='3'
163: WHERE STATUS = '2'
164: AND interface_run_id = p_interface_run_id
165: AND EXISTS ( SELECT 1
166: FROM igs_ad_appl_hist
167: WHERE person_id = in_rec.person_id
168: AND admission_appl_number = in_rec.admission_appl_number);
169:
170: COMMIT;

Line 220: igs_ad_appl_hist_pkg.insert_row (

216: OPEN c_appl_dtls_cur(appl_hist_rec.person_id, appl_hist_rec.admission_appl_number);
217: FETCH c_appl_dtls_cur INTO appl_dtls_rec;
218: CLOSE c_appl_dtls_cur;
219:
220: igs_ad_appl_hist_pkg.insert_row (
221: x_rowid => l_rowid,
222: x_org_id => NULL,
223: x_person_id => appl_hist_rec.person_id,
224: x_admission_appl_number => appl_hist_rec.admission_appl_number,

Line 352: cp_hist_start_dt igs_ad_appl_hist.hist_start_dt%TYPE) IS

348: CURSOR c_applinst_dup_hist_cur(cp_person_id igs_ad_appl.person_id%TYPE,
349: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,
350: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
351: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
352: cp_hist_start_dt igs_ad_appl_hist.hist_start_dt%TYPE) IS
353: SELECT
354: 'X'
355: FROM igs_ad_ps_aplinsthst
356: WHERE person_id = cp_person_id