DBA Data[Home] [Help]

APPS.IGS_PR_CLASS_RANK dependencies on IGS_PR_COHORT_INST_V

Line 61: FROM igs_pr_cohort_inst_v cohiv

57: CURSOR cur_inst_query (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
58: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
59: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE) IS
60: SELECT cohiv.*
61: FROM igs_pr_cohort_inst_v cohiv
62: WHERE cohiv.cohort_name = cp_cohort_name
63: AND cohiv.load_cal_type = cp_cal_type
64: AND cohiv.load_ci_sequence_number = cp_ci_sequence_number ;
65:

Line 402: FROM igs_pr_cohort_inst_v

398: CURSOR cur_rank_status (cp_cohort_name igs_pr_cohort_inst.cohort_name%TYPE,
399: cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE,
400: cp_ci_sequence_number igs_pr_cohort_inst.load_ci_sequence_number%TYPE ) IS
401: SELECT *
402: FROM igs_pr_cohort_inst_v
403: WHERE cohort_name = cp_cohort_name
404: AND load_cal_type = cp_cal_type
405: AND load_ci_sequence_number = cp_ci_sequence_number;
406: