APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_AS_ASSESSMNT_ITM

Line 625: FROM igs_as_assessmnt_itm ai,

621: CURSOR c_assessment_id (cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
622: SELECT ai.ass_id,
623: gs.grading_schema_cd,
624: gs.version_number
625: FROM igs_as_assessmnt_itm ai,
626: igs_as_grd_schema gs
627: WHERE (ai.assessment_type = p_assessment_type
628: OR p_assessment_type IS NULL
629: )

Line 708: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,

704: --
705: --
706: CURSOR c_ass_item_exist (
707: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
708: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
709: cp_person_id hz_parties.party_id%TYPE,
710: cp_reference VARCHAR2
711: ) IS
712: SELECT 'X'

Line 726: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,

722: --
723: CURSOR c_ass_item_grade_exist (
724: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
725: cp_person_id hz_parties.party_id%TYPE,
726: cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE,
727: cp_reference VARCHAR2
728: ) IS
729: SELECT sai.outcome_dt outcome_dt
730: FROM igs_as_su_atmpt_itm sai