APPS.IGS_EN_GEN_LEGACY dependencies on IGS_EN_DCNT_REASONCD

Line 121: FROM igs_en_dcnt_reasoncd

117: --
118: -- Cursor to to check if the Discontinuation Reason Code is valid, and can be used for discontinuing a Unit.
119: CURSOR val_discn_cd IS
120: SELECT dcnt_unit_ind
121: FROM igs_en_dcnt_reasoncd
122: WHERE discontinuation_reason_cd = p_discontinuation_reason_cd;
123:
124: l_discn_ind igs_en_dcnt_reasoncd.dcnt_unit_ind%TYPE;
125:

Line 124: l_discn_ind igs_en_dcnt_reasoncd.dcnt_unit_ind%TYPE;

120: SELECT dcnt_unit_ind
121: FROM igs_en_dcnt_reasoncd
122: WHERE discontinuation_reason_cd = p_discontinuation_reason_cd;
123:
124: l_discn_ind igs_en_dcnt_reasoncd.dcnt_unit_ind%TYPE;
125:
126: BEGIN
127: OPEN val_discn_cd ;
128: FETCH val_discn_cd INTO l_discn_ind ;

Line 246: FROM igs_en_stdnt_ps_att spa , igs_en_dcnt_reasoncd disc

242: --
243: -- Cursor to get the type of discontinuation reason code of a program
244: CURSOR get_prgm_reasn IS
245: SELECT 'x'
246: FROM igs_en_stdnt_ps_att spa , igs_en_dcnt_reasoncd disc
247: WHERE spa.person_id = p_person_id AND
248: spa.course_cd = p_transfer_program_cd AND
249: disc.discontinuation_reason_cd = spa.discontinuation_reason_cd AND
250: disc.s_discontinuation_reason_type = 'TRANSFER';