APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_AS_MSHT_SU_ATMPT

Line 1663: FROM IGS_AS_MSHT_SU_ATMPT as_msht_su_atmpt

1659: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1660: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1661: IS
1662: SELECT rowid
1663: FROM IGS_AS_MSHT_SU_ATMPT as_msht_su_atmpt
1664: WHERE as_msht_su_atmpt.person_id = cp_person_id
1665: AND as_msht_su_atmpt.course_cd = cp_course_cd
1666: AND as_msht_su_atmpt.uoo_id = cp_uoo_id;
1667: v_del_as_msht_su_atmpt c_del_as_msht_su_atmpt%ROWTYPE;

Line 1672: IGS_AS_MSHT_SU_ATMPT_PKG.DELETE_ROW(v_del_as_msht_su_atmpt.rowid);

1668:
1669: BEGIN
1670:
1671: FOR v_del_as_msht_su_atmpt IN c_del_as_msht_su_atmpt(p_person_id,p_course_cd,p_uoo_id) LOOP
1672: IGS_AS_MSHT_SU_ATMPT_PKG.DELETE_ROW(v_del_as_msht_su_atmpt.rowid);
1673:
1674: END LOOP;
1675:
1676: EXCEPTION