eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_CLASS_RANK dependencies on IGS_CA_TYPE

Line 430: FROM igs_ca_type

426: -- Cursor to determine the Calander Category for a particular calander type
427:
428: CURSOR cur_cal_cat (cp_cal_type igs_pr_cohort_inst.load_cal_type%TYPE ) IS
429: SELECT s_cal_cat
430: FROM igs_ca_type
431: WHERE cal_type = cp_cal_type ;
432:
433: -- Cursor to determine the Academic Calander for the corrosponding load calander
434:

Line 442: AND sup_cal_type IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC') ;

438: FROM igs_ca_inst_rel
439: WHERE
440: sub_cal_type = cp_cal_type
441: AND sub_ci_sequence_number = cp_ci_sequence_number
442: AND sup_cal_type IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC') ;
443:
444: --
445: -- Cursor used to rank the student based on the Rule. This is done when the rank status is not FINAL and the cohort status is WORKING
446: -- This cursor is used when,the Dense Rank Indicator is set as 'N' in the table igs_pr_cohort