[Home] [Help]
1172: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1173: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1174: l_commencement_type VARCHAR2(20);
1175: l_dummy VARCHAR2(100);
1176: l_enroll_mtd_type IGS_EN_METHOD_TYPE.ENR_METHOD_TYPE%TYPE;
1177: l_personsteps_vald_status BOOLEAN;
1178:
1179: CURSOR c_get_enr_method_type IS
1180: SELECT enr_method_type
1177: l_personsteps_vald_status BOOLEAN;
1178:
1179: CURSOR c_get_enr_method_type IS
1180: SELECT enr_method_type
1181: FROM IGS_EN_METHOD_TYPE
1182: WHERE transfer_flag = 'Y' AND
1183: closed_ind ='N';
1184:
1185: BEGIN
2066:
2067: -- added by ckasu as a part of bug#5070732
2068: CURSOR c_get_enr_method_type IS
2069: SELECT enr_method_type
2070: FROM IGS_EN_METHOD_TYPE
2071: WHERE transfer_flag = 'Y'
2072: AND closed_ind ='N';
2073:
2074: