DBA Data[Home] [Help]

APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_AS_SUA_REF_CDS

Line 1290: From IGS_AS_SUA_REF_CDS sref

1286: ORDER BY load_start_dt ASC;
1287:
1288: CURSOR cur_sua_ref_cds IS
1289: Select sref.rowid,sref.*
1290: From IGS_AS_SUA_REF_CDS sref
1291: Where sref.person_id = old_references.person_id
1292: And sref.course_cd = old_references.course_cd
1293: And sref.uoo_id = old_references.uoo_id
1294: And sref.deleted_date is null;

Line 1368: igs_as_sua_ref_cds_pkg.update_row (

1364: old_references.unit_attempt_status <> 'DROPPED' AND
1365: new_references.unit_attempt_status = 'DROPPED' THEN
1366:
1367: FOR v_cur_sua_ref_cds IN cur_sua_ref_cds LOOP
1368: igs_as_sua_ref_cds_pkg.update_row (
1369: x_rowid => v_cur_sua_ref_cds.rowid,
1370: x_suar_id => v_cur_sua_ref_cds.suar_id,
1371: x_person_id => v_cur_sua_ref_cds.person_id,
1372: x_course_cd => v_cur_sua_ref_cds.course_cd,