APPS.IGS_AS_GEN_004 dependencies on IGS_CA_INST

Line 723: cp_assess_cal_type IN igs_ca_inst.cal_type%TYPE,

719: v_student_sequence igs_as_msht_su_atmpt.student_sequence%TYPE;
720: v_update_on igs_as_msht_su_atmpt.last_update_date%TYPE;
721: v_update_who igs_as_msht_su_atmpt.last_updated_by%TYPE;
722: CURSOR c_uop (
723: cp_assess_cal_type IN igs_ca_inst.cal_type%TYPE,
724: cp_assess_sequence_number IN igs_ca_inst.sequence_number%TYPE,
725: cp_teach_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
726: cp_teach_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE
727: ) IS

Line 724: cp_assess_sequence_number IN igs_ca_inst.sequence_number%TYPE,

720: v_update_on igs_as_msht_su_atmpt.last_update_date%TYPE;
721: v_update_who igs_as_msht_su_atmpt.last_updated_by%TYPE;
722: CURSOR c_uop (
723: cp_assess_cal_type IN igs_ca_inst.cal_type%TYPE,
724: cp_assess_sequence_number IN igs_ca_inst.sequence_number%TYPE,
725: cp_teach_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
726: cp_teach_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE
727: ) IS
728: SELECT DISTINCT uop.unit_cd,

Line 737: igs_ca_inst ci,

733: ucl.unit_mode,
734: uop.uoo_id
735: FROM igs_ps_unit_ofr_opt uop,
736: igs_as_unit_class ucl,
737: igs_ca_inst ci,
738: igs_ps_unit_ver uv,
739: igs_ca_stat cs,
740: igs_ps_unit_stat us
741: WHERE uop.unit_cd LIKE p_unit_cd