APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_COHORT_INST_RANK_V

Line 466: FROM igs_pr_cohort_inst_rank_v cohi

462: CURSOR cur_old_rank (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
463: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
464: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
465: SELECT cohi.*
466: FROM igs_pr_cohort_inst_rank_v cohi
467: WHERE cohi.cohort_name = cp_cohort_name
468: AND cohi.load_cal_type = cp_cal_type
469: AND cohi.load_ci_sequence_number = cp_ci_sequence_number ;
470:

Line 480: FROM igs_pr_cohort_inst_rank_v cohi

476: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
477: cp_person_id igs_en_sca_v.person_id%TYPE,
478: cp_course_cd igs_en_sca_v.course_cd%TYPE) IS
479: SELECT cohi.*
480: FROM igs_pr_cohort_inst_rank_v cohi
481: WHERE cohi.cohort_name = cp_cohort_name
482: AND cohi.load_cal_type = cp_cal_type
483: AND cohi.load_ci_sequence_number = cp_ci_sequence_number
484: AND cohi.person_id = cp_person_id

Line 629: -- This means that the student population is frozen. The student population is chosen from IGS_PR_COHORT_INST_RANK_V. This is the population that needs to be ranked.

625:
626: END IF; --3
627:
628: -- Ranking for the student are done for the students where the rank status is working and the cohort status is 'FROZEN'
629: -- This means that the student population is frozen. The student population is chosen from IGS_PR_COHORT_INST_RANK_V. This is the population that needs to be ranked.
630:
631: IF rank_status_rec.cohort_status = 'FROZEN' THEN --2
632: p_count := 0;
633:

Line 654: FROM igs_pr_cohort_inst_rank_v cohiv

650: cohiv.load_ci_sequence_number,
651: ''' || stat_type_rec.stat_type || ''',
652: '''|| l_cumulative_ind || '''
653: ) cum_gpa
654: FROM igs_pr_cohort_inst_rank_v cohiv
655: WHERE cohiv.cohort_name = ''' || p_cohort_name || '''
656: AND cohiv.load_cal_type = ''' || p_cal_type || '''
657: AND cohiv.load_ci_sequence_number = ' || p_ci_sequence_number || ') res' ;
658:

Line 714: FROM igs_pr_cohort_inst_rank_v cohiv

710: cohiv.load_ci_sequence_number,
711: ''' || stat_type_rec.stat_type || ''',
712: '''|| l_cumulative_ind || '''
713: ) cum_gpa
714: FROM igs_pr_cohort_inst_rank_v cohiv
715: WHERE cohiv.cohort_name = ''' || p_cohort_name || '''
716: AND cohiv.load_cal_type = ''' || p_cal_type || '''
717: AND cohiv.load_ci_sequence_number = ' || p_ci_sequence_number || ') res' ;
718:

Line 1535: FROM igs_pr_cohort_inst_rank_v cohirv

1531: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE,
1532: cp_person_id igs_pr_cohinst_rank.person_id%TYPE,
1533: cp_program_cd igs_pr_cohinst_rank.course_cd%TYPE) IS
1534: SELECT NVL(cohort_override_rank, cohort_rank)
1535: FROM igs_pr_cohort_inst_rank_v cohirv
1536: WHERE cohirv.cohort_name = cp_cohort_name
1537: AND cohirv.load_cal_type = cp_cal_type
1538: AND cohirv.load_ci_sequence_number = cp_ci_sequence_number
1539: AND cohirv.person_id = cp_person_id

Line 1548: FROM igs_pr_cohort_inst_rank_v cohirv

1544: CURSOR c_cohort_population (cp_cohort_name igs_pr_cohort.cohort_name%TYPE,
1545: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
1546: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
1547: SELECT COUNT (*)
1548: FROM igs_pr_cohort_inst_rank_v cohirv
1549: WHERE cohirv.cohort_name = cp_cohort_name
1550: AND cohirv.load_cal_type = cp_cal_type
1551: AND cohirv.load_ci_sequence_number = cp_ci_sequence_number;
1552: