APPS.IGS_AD_IMP_027 dependencies on IGS_AD_PS_APLINSTHST

Line 355: FROM igs_ad_ps_aplinsthst

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
357: AND admission_appl_number = cp_adm_appl_number
358: AND nominated_course_cd = cp_nominated_course_cd
359: AND sequence_number = cp_sequence_number

Line 505: AND EXISTS ( SELECT 1 FROM igs_ad_ps_aplinsthst

501: , status ='3'
502: , error_text = cst_et_val_E689
503: WHERE STATUS = '2'
504: AND interface_run_id = p_interface_run_id
505: AND EXISTS ( SELECT 1 FROM igs_ad_ps_aplinsthst
506: WHERE person_id = in_rec.person_id
507: AND admission_appl_number = in_rec.admission_appl_number
508: AND nominated_course_cd = in_rec.nominated_course_cd
509: AND sequence_number = in_rec.sequence_number );

Line 596: igs_ad_ps_aplinsthst_pkg.insert_row(

592: applinst_hist_rec.nominated_course_cd,
593: applinst_hist_rec.sequence_number);
594: FETCH c_applinst_dtls_cur INTO applinst_dtls_rec;
595: CLOSE c_applinst_dtls_cur;
596: igs_ad_ps_aplinsthst_pkg.insert_row(
597: x_rowid => l_rowid,
598: x_org_id => null ,
599: x_person_id => applinst_hist_rec.person_id,
600: x_admission_appl_number => applinst_hist_rec.admission_appl_number,