APPS.IGS_EN_GEN_010 dependencies on IGS_EN_DCNT_REASONCD

Line 9364: FROM IGS_EN_DCNT_REASONCD

9360: l_destn_course_type igs_ps_ver.course_type%TYPE;
9361:
9362: CURSOR c_unit_dcnt is
9363: SELECT DISCONTINUATION_REASON_CD
9364: FROM IGS_EN_DCNT_REASONCD
9365: WHERE S_DISCONTINUATION_REASON_TYPE = 'UNIT_TRANS'
9366: AND DCNT_UNIT_IND = 'Y'
9367: AND SYS_DFLT_IND = 'Y'
9368: AND CLOSED_IND = 'N';

Line 9370: l_unt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;

9366: AND DCNT_UNIT_IND = 'Y'
9367: AND SYS_DFLT_IND = 'Y'
9368: AND CLOSED_IND = 'N';
9369:
9370: l_unt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
9371: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
9372:
9373: CURSOR c_dcnt_rsn IS
9374: SELECT discontinuation_reason_cd

Line 9371: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;

9367: AND SYS_DFLT_IND = 'Y'
9368: AND CLOSED_IND = 'N';
9369:
9370: l_unt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
9371: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
9372:
9373: CURSOR c_dcnt_rsn IS
9374: SELECT discontinuation_reason_cd
9375: FROM igs_en_dcnt_reasoncd

Line 9375: FROM igs_en_dcnt_reasoncd

9371: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
9372:
9373: CURSOR c_dcnt_rsn IS
9374: SELECT discontinuation_reason_cd
9375: FROM igs_en_dcnt_reasoncd
9376: WHERE NVL(closed_ind,'N') ='N'
9377: AND dflt_ind ='Y'
9378: AND dcnt_unit_ind ='Y'
9379: AND s_discontinuation_reason_type IS NULL;