[Home] [Help]
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
144: AND ftci.fee_type_ci_status = fst.fee_structure_status