APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_AS_SU_ATMPT_ITM

Line 137: FROM igs_as_su_atmpt_itm suaai

133: cp_ass_id NUMBER,
134: cp_reference VARCHAR2
135: ) IS
136: SELECT suaai.*, suaai.rowid
137: FROM igs_as_su_atmpt_itm suaai
138: WHERE suaai.person_id = cp_person_id
139: AND suaai.course_cd = cp_course_cd
140: AND suaai.uoo_id = cp_uoo_id
141: AND suaai.ass_id = cp_ass_id

Line 374: igs_as_su_atmpt_itm_pkg.update_row (

370: --
371: IF cur_suaai%FOUND THEN -- that means record is already exist into base table
372: CLOSE cur_suaai;
373: BEGIN
374: igs_as_su_atmpt_itm_pkg.update_row (
375: x_rowid => rec_suaai.rowid,
376: x_person_id => rec_suaai.person_id,
377: x_course_cd => rec_suaai.course_cd,
378: x_unit_cd => rec_suaai.unit_cd,

Line 713: FROM igs_as_su_atmpt_itm sai

709: cp_person_id hz_parties.party_id%TYPE,
710: cp_reference VARCHAR2
711: ) IS
712: SELECT 'X'
713: FROM igs_as_su_atmpt_itm sai
714: WHERE sai.person_id = cp_person_id
715: AND sai.course_cd = p_course_cd
716: AND sai.uoo_id = cp_uoo_id
717: AND sai.ass_id = cp_ass_id

Line 730: FROM igs_as_su_atmpt_itm sai

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
731: WHERE sai.person_id = cp_person_id
732: AND sai.course_cd = p_course_cd
733: AND sai.uoo_id = cp_uoo_id
734: AND sai.ass_id = cp_ass_id