[Home] [Help]
152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
154: SELECT 'x'
155: FROM igs_fi_f_typ_ca_inst ftci,
156: igs_fi_fee_str_stat fsst
157: WHERE ftci.fee_cal_type = cp_c_fee_cal_type
158: AND ftci.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
159: AND ftci.fee_type = cp_c_fee_type
160: AND ftci.fee_type_ci_status = fsst.fee_structure_status
216: cp_c_status VARCHAR2,
217: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
218: SELECT 'x'
219: FROM igs_fi_f_cat_fee_lbl fcfl,
220: igs_fi_fee_str_stat fsst
221: WHERE fcfl.fee_cat = cp_c_fee_cat
222: AND fcfl.fee_type = cp_c_fee_type
223: AND fcfl.fee_liability_status = fsst.fee_structure_status
224: AND (