APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USO_CLAS_MEET_V

Line 870: CURSOR c_cm_grp(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS

866: AND class_meet_group_id =cp_class_meet_group_id;
867:
868: c_host_rec c_host%ROWTYPE;
869:
870: CURSOR c_cm_grp(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
871: SELECT *
872: FROM igs_ps_uso_cm_grp
873: WHERE class_meet_group_id = cp_class_meet_group_id;
874:

Line 878: CURSOR c_sum_enract(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS

874:
875: c_cm_grp_rec c_cm_grp%ROWTYPE;
876:
877:
878: CURSOR c_sum_enract(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
879: SELECT SUM(enrollment_actual) sum_enrollment_actual
880: FROM igs_ps_uso_clas_meet_v
881: WHERE class_meet_group_id = cp_class_meet_group_id ;
882:

Line 880: FROM igs_ps_uso_clas_meet_v

876:
877:
878: CURSOR c_sum_enract(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
879: SELECT SUM(enrollment_actual) sum_enrollment_actual
880: FROM igs_ps_uso_clas_meet_v
881: WHERE class_meet_group_id = cp_class_meet_group_id ;
882:
883: c_sum_enract_rec c_sum_enract%ROWTYPE;
884:

Line 885: CURSOR c_usec_enr(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS

881: WHERE class_meet_group_id = cp_class_meet_group_id ;
882:
883: c_sum_enract_rec c_sum_enract%ROWTYPE;
884:
885: CURSOR c_usec_enr(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
886: SELECT *
887: FROM igs_ps_uso_clas_meet_v
888: WHERE class_meet_group_id = cp_class_meet_group_id ;
889:

Line 887: FROM igs_ps_uso_clas_meet_v

883: c_sum_enract_rec c_sum_enract%ROWTYPE;
884:
885: CURSOR c_usec_enr(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
886: SELECT *
887: FROM igs_ps_uso_clas_meet_v
888: WHERE class_meet_group_id = cp_class_meet_group_id ;
889:
890: c_usec_enr_rec c_usec_enr%ROWTYPE;
891: