APPS.IGS_EN_GEN_009 dependencies on IGS_EN_ENCMB_EFCTTYP_V

Line 60: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;

56: -- record
57: DECLARE
58: v_closed_ind VARCHAR2(1);
59: v_error_ind NUMBER(5) := 0;
60: v_apply_to_course_ind IGS_EN_ENCMB_EFCTTYP_V.apply_to_course_ind%TYPE;
61: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
62: v_pee_seq_num IGS_PE_PERSENC_EFFCT.sequence_number%TYPE;
63: v_message_string VARCHAR2(5512);
64: v_return_type VARCHAR2(1);

Line 66: cp_s_encmb_effect_type IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE) IS

62: v_pee_seq_num IGS_PE_PERSENC_EFFCT.sequence_number%TYPE;
63: v_message_string VARCHAR2(5512);
64: v_return_type VARCHAR2(1);
65: CURSOR c_s_encmb_effect_type (
66: cp_s_encmb_effect_type IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE) IS
67: SELECT closed_ind
68: FROM IGS_EN_ENCMB_EFCTTYP_V
69: WHERE s_encmb_effect_type = cp_s_encmb_effect_type;
70: CURSOR c_encmb_type_dflt_effect IS

Line 68: FROM IGS_EN_ENCMB_EFCTTYP_V

64: v_return_type VARCHAR2(1);
65: CURSOR c_s_encmb_effect_type (
66: cp_s_encmb_effect_type IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE) IS
67: SELECT closed_ind
68: FROM IGS_EN_ENCMB_EFCTTYP_V
69: WHERE s_encmb_effect_type = cp_s_encmb_effect_type;
70: CURSOR c_encmb_type_dflt_effect IS
71: SELECT eft.*,
72: seft.description encmb_meaning

Line 74: IGS_EN_ENCMB_EFCTTYP_V seft

70: CURSOR c_encmb_type_dflt_effect IS
71: SELECT eft.*,
72: seft.description encmb_meaning
73: FROM IGS_FI_ENC_DFLT_EFT eft,
74: IGS_EN_ENCMB_EFCTTYP_V seft
75: WHERE eft.encumbrance_type = p_encumbrance_type AND
76: eft.s_encmb_effect_type = seft.s_encmb_effect_type;
77:
78: CURSOR c_get_apply_to_crs_ind (cp_s_encmb_effect_type

Line 81: FROM IGS_EN_ENCMB_EFCTTYP_V

77:
78: CURSOR c_get_apply_to_crs_ind (cp_s_encmb_effect_type
79: IGS_FI_ENC_DFLT_EFT.s_encmb_effect_type%TYPE) IS
80: SELECT apply_to_course_ind
81: FROM IGS_EN_ENCMB_EFCTTYP_V
82: WHERE s_encmb_effect_type = cp_s_encmb_effect_type;
83: CURSOR c_student_course_attempt IS
84: SELECT course_cd
85: FROM IGS_EN_STDNT_PS_ATT