APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_RE_CANDIDATURE

Line 941: FROM igs_re_candidature

937:
938: CURSOR cur_re_canditure(cp_person_id igs_pe_person.person_id%TYPE,
939: cp_course_cd igs_ps_ver.course_cd%TYPE) IS
940: SELECT 1
941: FROM igs_re_candidature
942: WHERE sca_course_cd = cp_course_cd
943: AND person_id = cp_person_id ;
944:
945:

Line 1284: -- 2. If there is a corresponding record exist in IGS_RE_CANDIDATURE

1280:
1281: -- The changes are done as per the Enrollments Notifications TD Bug # 3052429
1282: -- Workflow notification is send if :
1283: -- 1. The program status changed from UNCONFIRM to INACTIVE
1284: -- 2. If there is a corresponding record exist in IGS_RE_CANDIDATURE
1285:
1286:
1287: IF ( new_references.course_attempt_status <> old_references.course_attempt_status
1288: AND new_references.course_attempt_status ='INACTIVE' AND old_references.course_attempt_status = 'UNCONFIRM') THEN

Line 2106: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

2102: IGS_AD_PS_APPL_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2103: old_references.person_id,
2104: old_references.course_cd
2105: );
2106: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2107: old_references.person_id,
2108: old_references.course_cd
2109: );
2110: IGS_FI_FEE_AS_RT_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (