APPS.IGS_AD_SUSPEND_APPL_PKG dependencies on IGS_AD_OU_STAT

Line 42: FROM igs_ad_ou_stat

38: SELECT a.*
39: FROM igs_ad_ps_appl_inst a
40: WHERE a.adm_outcome_status IN
41: ( SELECT adm_outcome_status
42: FROM igs_ad_ou_stat
43: WHERE s_adm_outcome_status = 'SUSPEND') ;
44:
45: CURSOR c_all_records_case_2(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE) IS
46: SELECT a.*

Line 55: FROM igs_ad_ou_stat

51: a.admission_appl_number = b.admission_appl_number AND
52: b.acad_cal_type = cp_acad_cal_type AND
53: b.acad_ci_sequence_number = cp_acad_ci_sequence_number AND
54: a.adm_outcome_status IN (SELECT adm_outcome_status
55: FROM igs_ad_ou_stat
56: WHERE s_adm_outcome_status = 'SUSPEND');
57:
58: CURSOR c_all_records_case_3(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
59: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,

Line 71: FROM igs_ad_ou_stat

67: b.acad_ci_sequence_number = cp_acad_ci_sequence_number AND
68: b.adm_cal_type = cp_adm_cal_type AND
69: b.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
70: a.adm_outcome_status IN (SELECT adm_outcome_status
71: FROM igs_ad_ou_stat
72: WHERE s_adm_outcome_status = 'SUSPEND');
73:
74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,

Line 91: FROM igs_ad_ou_stat

87: b.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
88: b.admission_cat = cp_adm_cat AND
89: b.s_admission_process_type = cp_admission_process_type AND
90: a.adm_outcome_status IN (SELECT adm_outcome_status
91: FROM igs_ad_ou_stat
92: WHERE s_adm_outcome_status = 'SUSPEND');
93:
94:
95: CURSOR c_get_alt_code(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_no igs_ca_inst.sequence_number%TYPE) IS