DBA Data[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on IGS_FI_FEE_RET_SCHD_F_TYPE_V

Line 514: FROM igs_fi_fee_ret_schd_f_type_v

510: cp_n_fee_ci_seq_num igs_fi_fee_ret_schd.fee_ci_sequence_number%TYPE,
511: cp_v_fee_cat igs_fi_fee_ret_schd.fee_cat%TYPE) IS
512: SELECT retention_percentage,
513: retention_amount
514: FROM igs_fi_fee_ret_schd_f_type_v
515: WHERE fee_type = cp_v_fee_type
516: AND fee_cal_type = cp_v_fee_cal_type
517: AND fee_ci_sequence_number = cp_n_fee_ci_seq_num
518: AND ( (fee_cat = cp_v_fee_cat) OR (fee_cat IS NULL) )