132: ORDER BY due_date;
133:
134: --Cursor to validate if the Fee Type and Fee Calendar Instance combination is an active combination.
135: CURSOR cur_validate_ftci(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
138: SELECT 'x'
139: FROM igs_fi_f_typ_ca_inst ftci,
140: igs_fi_fee_str_stat fst
133:
134: --Cursor to validate if the Fee Type and Fee Calendar Instance combination is an active combination.
135: CURSOR cur_validate_ftci(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
138: SELECT 'x'
139: FROM igs_fi_f_typ_ca_inst ftci,
140: igs_fi_fee_str_stat fst
141: WHERE ftci.fee_type = cp_v_fee_type
135: CURSOR cur_validate_ftci(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
136: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
137: cp_n_fee_ci_seq_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
138: SELECT 'x'
139: FROM igs_fi_f_typ_ca_inst ftci,
140: igs_fi_fee_str_stat fst
141: WHERE ftci.fee_type = cp_v_fee_type
142: AND ftci.fee_cal_type = cp_v_fee_cal_type
143: AND ftci.fee_ci_sequence_number = cp_n_fee_ci_seq_number