APPS.IGS_AD_SUSPEND_APPL_PKG dependencies on IGS_CA_INST

Line 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

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
96: SELECT alternate_code
97: FROM IGS_CA_INST
98: WHERE cal_type = cp_cal_type AND
99: sequence_number = cp_seq_no;

Line 97: FROM IGS_CA_INST

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
96: SELECT alternate_code
97: FROM IGS_CA_INST
98: WHERE cal_type = cp_cal_type AND
99: sequence_number = cp_seq_no;
100:
101:

Line 108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;

104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;
109: lv_alt_code_adm igs_ca_inst.alternate_code%TYPE;
110:
111:
112: CASE_1 BOOLEAN;

Line 109: lv_alt_code_adm igs_ca_inst.alternate_code%TYPE;

105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;
109: lv_alt_code_adm igs_ca_inst.alternate_code%TYPE;
110:
111:
112: CASE_1 BOOLEAN;
113: CASE_2 BOOLEAN;