[Home] [Help]
254:
255: --
256: --Get the Segment Values for the Fee Type Entity
257: --
258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
255: --
256: --Get the Segment Values for the Fee Type Entity
257: --
258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
263: FROM igs_fi_f_type_accts
256: --Get the Segment Values for the Fee Type Entity
257: --
258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
263: FROM igs_fi_f_type_accts
264: WHERE fee_type = cp_fee_type
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
263: FROM igs_fi_f_type_accts
264: WHERE fee_type = cp_fee_type
265: AND fee_cal_type = cp_fee_cal_type
266: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
267: