APPS.IGS_AS_GEN_003 dependencies on IGS_PS_USEC_GRD_SCHM_V

Line 416: FROM igs_ps_usec_grd_schm_v gs,

412: DECLARE
413: CURSOR c_usec_gs IS
414: SELECT gs.grading_schema_code grading_schema_code,
415: gs.grd_schm_version_number grd_schm_version_number
416: FROM igs_ps_usec_grd_schm_v gs,
417: igs_ps_unit_ofr_opt uoo
418: WHERE uoo.unit_cd = p_unit_cd
419: AND uoo.version_number = p_version_number
420: AND uoo.cal_type = p_cal_type

Line 439: -- which is now changed to igs_ps_usec_grd_schm_v since the concept of having

435: v_ret BOOLEAN DEFAULT FALSE;
436: BEGIN
437: --
438: -- This cursor used in this code was earlier referring to igs_ps_unit_ofr_opt
439: -- which is now changed to igs_ps_usec_grd_schm_v since the concept of having
440: -- multiple grading schemas was introduced by some enhancements.
441: --
442: -- This routine is built to select the grading schema from the link
443: -- to the igs_ps_usec_grd_schm_v table, however in future there will

Line 443: -- to the igs_ps_usec_grd_schm_v table, however in future there will

439: -- which is now changed to igs_ps_usec_grd_schm_v since the concept of having
440: -- multiple grading schemas was introduced by some enhancements.
441: --
442: -- This routine is built to select the grading schema from the link
443: -- to the igs_ps_usec_grd_schm_v table, however in future there will
444: -- also be links to igs_ps_ofr_pat and igs_en_stdnt_ps_att
445: --
446: OPEN c_usec_gs;
447: FETCH c_usec_gs INTO v_grading_schema, v_gs_version_number;