DBA Data[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on IGS_AD_CODE_CLASSES

Line 2702: IGS_AD_CODE_CLASSES B

2698: --Gets the grades assigned to the student (person_id) for the admission test (cp_c_grade)
2699: CURSOR c_tst_grade (cp_n_person_id IN NUMBER, cp_c_grade IN VARCHAR2) IS
2700: SELECT DISTINCT B.NAME GRADE
2701: FROM IGS_AD_TEST_RESULTS A,
2702: IGS_AD_CODE_CLASSES B
2703: WHERE A.PERSON_ID = cp_n_person_id
2704: AND A.ADMISSION_TEST_TYPE = cp_c_grade
2705: AND A.GRADE_ID IS NOT NULL
2706: AND A.ACTIVE_IND = 'Y'