APPS.IGS_SS_ENROLL_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 389: insert into igs_en_su_attempt

385: else
386: l_course_cd := p_course_cd ;
387: end if ;
388: begin
389: insert into igs_en_su_attempt
390: (
391: org_id,
392: person_id,
393: course_cd,

Line 487: delete from igs_en_su_attempt

483: )
484: is
485: begin
486: begin
487: delete from igs_en_su_attempt
488: where person_id = p_person_id
489: and course_cd = p_course_cd
490: and uoo_id = p_uoo_id
491: and org_id = p_org_id ;

Line 856: FROM igs_en_su_attempt

852: --
853: -------------------------------------------------------------------
854: CURSOR cur_usec_trns IS
855: SELECT 'X'
856: FROM igs_en_su_attempt
857: WHERE person_id = p_person_id
858: AND course_cd = p_program_cd
859: AND uoo_id = p_uoo_id
860: AND unit_Attempt_status <> 'DROPPED';

Line 932: igs_en_su_attempt sua

928: -------------------------------------------------------------------
929: CURSOR cur_src_unit_atmpt IS
930: SELECT sut.transfer_course_cd
931: FROM igs_ps_stdnt_unt_trn sut,
932: igs_en_su_attempt sua
933: WHERE sut.person_id = p_person_id
934: AND sua.person_id = sut.person_id
935: AND sut.uoo_id = p_uoo_id
936: AND sua.uoo_id = sut.uoo_id