APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_AS_SUA_REF_CDS

Line 1267: From IGS_AS_SUA_REF_CDS suar

1263: CURSOR cur_sua_ref_cds(cp_person_id NUMBER,
1264: cp_course_cd VARCHAR2,
1265: cp_uoo_id NUMBER) IS
1266: Select suar.rowid
1267: From IGS_AS_SUA_REF_CDS suar
1268: Where suar.person_id = cp_person_id
1269: And suar.course_cd = cp_course_cd
1270: And suar.uoo_id = cp_uoo_id;
1271:

Line 1274: igs_as_sua_ref_cds_pkg.delete_row(v_cur_sua_ref_cds.rowid);

1270: And suar.uoo_id = cp_uoo_id;
1271:
1272: BEGIN
1273: FOR v_cur_sua_ref_cds IN cur_sua_ref_cds(p_person_id,p_course_cd,p_uoo_id) LOOP
1274: igs_as_sua_ref_cds_pkg.delete_row(v_cur_sua_ref_cds.rowid);
1275: END LOOP;
1276:
1277: EXCEPTION
1278: WHEN e_resource_busy THEN