APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_CA_INST

Line 517: p_acad_cal_type igs_ca_inst.cal_type%TYPE,

513:
514: -- Cursor for getting the alternade academic/admission code for a given academic/admission cal type and sequence number
515:
516: CURSOR acad_adm_alt_code (
517: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
518: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
519: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
520: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
521: ) IS

Line 518: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

514: -- Cursor for getting the alternade academic/admission code for a given academic/admission cal type and sequence number
515:
516: CURSOR acad_adm_alt_code (
517: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
518: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
519: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
520: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
521: ) IS
522: SELECT c1.alternate_code||' / '||c2.alternate_code

Line 519: p_adm_cal_type igs_ca_inst.cal_type%TYPE,

515:
516: CURSOR acad_adm_alt_code (
517: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
518: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
519: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
520: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
521: ) IS
522: SELECT c1.alternate_code||' / '||c2.alternate_code
523: FROM igs_ca_inst c1, igs_ca_inst c2

Line 520: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE

516: CURSOR acad_adm_alt_code (
517: p_acad_cal_type igs_ca_inst.cal_type%TYPE,
518: p_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
519: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
520: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
521: ) IS
522: SELECT c1.alternate_code||' / '||c2.alternate_code
523: FROM igs_ca_inst c1, igs_ca_inst c2
524: WHERE c1.cal_type = p_acad_cal_type

Line 523: FROM igs_ca_inst c1, igs_ca_inst c2

519: p_adm_cal_type igs_ca_inst.cal_type%TYPE,
520: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE
521: ) IS
522: SELECT c1.alternate_code||' / '||c2.alternate_code
523: FROM igs_ca_inst c1, igs_ca_inst c2
524: WHERE c1.cal_type = p_acad_cal_type
525: AND c1.sequence_number = p_acad_ci_sequence_number
526: AND c2.cal_type = p_adm_cal_type
527: AND c2.sequence_number = p_adm_ci_sequence_number;