APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_AS_GRD_SCHEMA

Line 370: l_description igs_as_grd_schema.description%TYPE;

366: l_cur_assessment_id cur_assessment_id%ROWTYPE;
367:
368: l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;
369: l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;
370: l_description igs_as_grd_schema.description%TYPE;
371: l_approved VARCHAR2 (1);
372:
373: CURSOR cur_grading_approved(cp_unit_cd VARCHAR2,cp_version_number NUMBER,cp_assessment_type VARCHAR2,cp_grading_schema_cd VARCHAR2,cp_gs_version_number NUMBER) IS
374: SELECT 'X'

Line 376: igs_as_grd_schema grd

372:
373: CURSOR cur_grading_approved(cp_unit_cd VARCHAR2,cp_version_number NUMBER,cp_assessment_type VARCHAR2,cp_grading_schema_cd VARCHAR2,cp_gs_version_number NUMBER) IS
374: SELECT 'X'
375: FROM igs_as_appr_grd_sch agrs,
376: igs_as_grd_schema grd
377: WHERE grd.grading_schema_cd = agrs.grading_schema_cd
378: AND grd.version_number = agrs.gs_version_number
379: AND agrs.unit_cd = cp_unit_cd
380: AND agrs.version_number = cp_version_number

Line 388: FROM igs_as_grd_schema

384: AND agrs.gs_version_number = cp_gs_version_number;
385:
386: CURSOR cur_grading_assess(cp_grading_schema_cd VARCHAR2,cp_gs_version_number NUMBER) IS
387: SELECT 'X'
388: FROM igs_as_grd_schema
389: WHERE grading_schema_cd = cp_grading_schema_cd
390: AND version_number = cp_gs_version_number
391: AND NVL(end_dt,SYSDATE) >= SYSDATE
392: AND grading_schema_type = 'ASSESSMENT_ITEM';