APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_EN_DCNT_REASONCD

Line 176: FROM IGS_EN_DCNT_REASONCD

172: course_cd = p_course_cd;
173:
174: CURSOR c_get_discont_reason IS
175: SELECT discontinuation_reason_cd
176: FROM IGS_EN_DCNT_REASONCD
177: WHERE dcnt_program_ind = 'Y' AND
178: closed_ind = 'N' AND
179: sys_dflt_ind = 'Y' AND
180: s_discontinuation_reason_type = 'TRANSFER';

Line 190: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;

186: course_cd = p_src_course_cd;
187:
188: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
189: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
190: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
191: l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
192: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE := FND_API.G_MISS_CHAR;
193: l_message_name VARCHAR2(2000);
194: BEGIN

Line 2778: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;

2774:
2775:
2776: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2777: l_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2778: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
2779: l_status BOOLEAN;
2780: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2781: CURSOR c_course_type IS
2782: SELECT course_type

Line 2795: FROM IGS_EN_DCNT_REASONCD

2791: l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
2792:
2793: CURSOR c_get_discont_reason IS
2794: SELECT discontinuation_reason_cd
2795: FROM IGS_EN_DCNT_REASONCD
2796: WHERE dcnt_program_ind = 'Y' AND
2797: closed_ind = 'N' AND
2798: sys_dflt_ind = 'Y' AND
2799: s_discontinuation_reason_type = 'TRANSFER';