APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_CA_INST

Line 111: p_acad_cal_type igs_ca_inst.cal_type%TYPE,

107:
108: -- Cursor for getting the alternade academic/admission code for a given academic/admission cal type and sequence number
109:
110: CURSOR acad_adm_alt_code (
111: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
112: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
113: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
114: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
115: ) IS

Line 112: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

108: -- Cursor for getting the alternade academic/admission code for a given academic/admission cal type and sequence number
109:
110: CURSOR acad_adm_alt_code (
111: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
112: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
113: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
114: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
115: ) IS
116: SELECT c1.alternate_code||' / '||c2.alternate_code

Line 113: p_adm_cal_type igs_ca_inst.cal_type%TYPE,

109:
110: CURSOR acad_adm_alt_code (
111: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
112: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
113: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
114: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
115: ) IS
116: SELECT c1.alternate_code||' / '||c2.alternate_code
117: FROM igs_ca_inst c1, igs_ca_inst c2

Line 114: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE

110: CURSOR acad_adm_alt_code (
111: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
112: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
113: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
114: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
115: ) IS
116: SELECT c1.alternate_code||' / '||c2.alternate_code
117: FROM igs_ca_inst c1, igs_ca_inst c2
118: WHERE c1.cal_type = p_acad_cal_type

Line 117: FROM igs_ca_inst c1, igs_ca_inst c2

113: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
114: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
115: ) IS
116: SELECT c1.alternate_code||' / '||c2.alternate_code
117: FROM igs_ca_inst c1, igs_ca_inst c2
118: WHERE c1.cal_type = p_acad_cal_type
119: AND c1.sequence_number = p_acad_ci_sequence_number
120: AND c2.cal_type = p_adm_cal_type
121: AND c2.sequence_number = p_adm_ci_sequence_number;