DBA Data[Home] [Help]

APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_AS_GRD_SCHEMA

Line 626: igs_as_grd_schema gs

622: SELECT ai.ass_id,
623: gs.grading_schema_cd,
624: gs.version_number
625: FROM igs_as_assessmnt_itm ai,
626: igs_as_grd_schema gs
627: WHERE (ai.assessment_type = p_assessment_type
628: OR p_assessment_type IS NULL
629: )
630: AND (ai.ass_id = p_ass_id

Line 741: cp_grading_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE,

737: --
738: --
739: --
740: CURSOR c_grade_invalid (
741: cp_grading_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE,
742: cp_gs_version_number igs_as_grd_schema.version_number%TYPE
743: ) IS
744: SELECT gsg.lower_mark_range,
745: gsg.upper_mark_range

Line 742: cp_gs_version_number igs_as_grd_schema.version_number%TYPE

738: --
739: --
740: CURSOR c_grade_invalid (
741: cp_grading_schema_cd igs_as_grd_schema.grading_schema_cd%TYPE,
742: cp_gs_version_number igs_as_grd_schema.version_number%TYPE
743: ) IS
744: SELECT gsg.lower_mark_range,
745: gsg.upper_mark_range
746: FROM igs_as_grd_sch_grade gsg