DBA Data[Home] [Help]

APPS.IGS_AD_GEN_001 dependencies on IGS_CA_INST

Line 400: FROM IGS_CA_INST_REL cir,

396: SELECT cir.sup_cal_type,
397: cir.sup_ci_sequence_number,
398: daiv.cal_type,
399: daiv.ci_sequence_number
400: FROM IGS_CA_INST_REL cir,
401: IGS_CA_DA_INST_V daiv,
402: IGS_CA_TYPE ct,
403: IGS_CA_TYPE ct2,
404: IGS_EN_CAL_CONF secc

Line 416: cp_cal_type IGS_CA_INST.cal_type%TYPE,

412: ct2.cal_type = cir.sup_cal_type AND
413: ct2.s_cal_cat = cst_admission;
414:
415: CURSOR c_sca (
416: cp_cal_type IGS_CA_INST.cal_type%TYPE,
417: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
418: SELECT sca.person_id,
419: sca.course_cd,
420: sca.course_attempt_status,

Line 417: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

413: ct2.s_cal_cat = cst_admission;
414:
415: CURSOR c_sca (
416: cp_cal_type IGS_CA_INST.cal_type%TYPE,
417: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
418: SELECT sca.person_id,
419: sca.course_cd,
420: sca.course_attempt_status,
421: sca.fee_cat,