APPS.IGS_AS_GEN_003 dependencies on IGS_AS_GRD_SCHEMA

Line 433: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;

429: FROM igs_ps_unit_grd_schm_v gs
430: WHERE gs.unit_code = p_unit_cd
431: AND gs.unit_version_number = p_version_number
432: AND gs.default_flag = 'Y';
433: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;
434: v_gs_version_number igs_as_grd_schema.version_number%TYPE;
435: v_ret BOOLEAN DEFAULT FALSE;
436: BEGIN
437: --

Line 434: v_gs_version_number igs_as_grd_schema.version_number%TYPE;

430: WHERE gs.unit_code = p_unit_cd
431: AND gs.unit_version_number = p_version_number
432: AND gs.default_flag = 'Y';
433: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;
434: v_gs_version_number igs_as_grd_schema.version_number%TYPE;
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

Line 1228: FROM igs_as_grd_schema

1224:
1225: CURSOR cur_desc (p_grading_schema_cd VARCHAR2,
1226: p_gs_version_number NUMBER )IS
1227: SELECT description
1228: FROM igs_as_grd_schema
1229: WHERE grading_schema_cd = p_grading_schema_cd AND
1230: version_number = p_gs_version_number;
1231: l_cur_desc cur_desc%ROWTYPE;
1232: