APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_AS_ASSESSMNT_ITM

Line 351: CURSOR c_action_dt(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE,cp_uoo_id NUMBER,cp_sequence_number NUMBER) IS

347: WHERE uoo_id = cp_n_uoo_id;
348:
349: c_usec_rec c_usec%ROWTYPE;
350:
351: CURSOR c_action_dt(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE,cp_uoo_id NUMBER,cp_sequence_number NUMBER) IS
352: SELECT *
353: FROM igs_ps_unitass_item
354: WHERE ass_id =cp_assessment_id
355: AND uoo_id =cp_uoo_id

Line 362: CURSOR cur_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE ) IS

358: c_action_dt_rec c_action_dt%ROWTYPE;
359: l_c_message VARCHAR2(30);
360:
361:
362: CURSOR cur_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE ) IS
363: SELECT assessment_type
364: FROM igs_as_assessmnt_itm
365: WHERE ass_id = cp_assessment_id;
366: l_cur_assessment_id cur_assessment_id%ROWTYPE;

Line 364: FROM igs_as_assessmnt_itm

360:
361:
362: CURSOR cur_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE ) IS
363: SELECT assessment_type
364: FROM igs_as_assessmnt_itm
365: WHERE ass_id = cp_assessment_id;
366: l_cur_assessment_id cur_assessment_id%ROWTYPE;
367:
368: l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;