DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_PS_UNIT_GRD_SCHM

Line 2264: CURSOR cur_unit_grd_schm( cp_unit_code igs_ps_unit_grd_schm.unit_code%TYPE,

2260: FROM igs_ps_unit_ofr_opt
2261: WHERE uoo_id = p_uoo_id;
2262:
2263: -- cursor for getting the count of Grading Schema's for the Uoo_id passed at the Unit Section Level
2264: CURSOR cur_unit_grd_schm( cp_unit_code igs_ps_unit_grd_schm.unit_code%TYPE,
2265: cp_version_number igs_ps_unit_grd_schm.unit_version_number%TYPE
2266: )
2267: IS
2268: SELECT COUNT(1) num_grade_schemas

Line 2265: cp_version_number igs_ps_unit_grd_schm.unit_version_number%TYPE

2261: WHERE uoo_id = p_uoo_id;
2262:
2263: -- cursor for getting the count of Grading Schema's for the Uoo_id passed at the Unit Section Level
2264: CURSOR cur_unit_grd_schm( cp_unit_code igs_ps_unit_grd_schm.unit_code%TYPE,
2265: cp_version_number igs_ps_unit_grd_schm.unit_version_number%TYPE
2266: )
2267: IS
2268: SELECT COUNT(1) num_grade_schemas
2269: FROM igs_ps_unit_grd_schm

Line 2269: FROM igs_ps_unit_grd_schm

2265: cp_version_number igs_ps_unit_grd_schm.unit_version_number%TYPE
2266: )
2267: IS
2268: SELECT COUNT(1) num_grade_schemas
2269: FROM igs_ps_unit_grd_schm
2270: WHERE unit_code = cp_unit_code
2271: AND unit_version_number = cp_version_number;
2272:
2273: -- Cursor for getting different grading schema's defined for the logged on person type