DBA Data[Home] [Help]

APPS.IGS_EN_GEN_011 dependencies on IGS_PS_UNIT_GRD_SCHM

Line 3062: FROM igs_ps_unit_grd_schm

3058:
3059: -- Cursor to get the grading schema in Unit level
3060: CURSOR c_from_unit_grad_schm(l_unit_cd VARCHAR2, l_unit_version NUMBER) IS
3061: SELECT grading_schema_code, grd_schm_version_number
3062: FROM igs_ps_unit_grd_schm
3063: WHERE unit_code = l_unit_cd
3064: AND unit_version_number = l_unit_version
3065: AND default_flag = 'Y';
3066:

Line 3070: FROM igs_ps_unit_grd_schm

3066:
3067: -- Cursor to check the grading schema in source Unit level is default for the destination unit
3068: CURSOR c_unit_grad_schm(l_unit_cd VARCHAR2, l_unit_version NUMBER,p_grading_schema_code VARCHAR2, p_grd_schm_version_number NUMBER) IS
3069: SELECT grading_schema_code, grd_schm_version_number
3070: FROM igs_ps_unit_grd_schm
3071: WHERE unit_code = l_unit_cd
3072: AND unit_version_number = l_unit_version
3073: AND grading_schema_code = p_grading_schema_code
3074: AND grd_schm_version_number = p_grd_schm_version_number