APPS.IGS_FI_GEN_001 dependencies on IGS_FI_FEE_AS_RATE

Line 211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,

207: SELECT currency_cd
208: FROM IGS_FI_FEE_CAT fc
209: WHERE FEE_CAT = cp_fee_cat;
210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS

Line 212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

208: FROM IGS_FI_FEE_CAT fc
209: WHERE FEE_CAT = cp_fee_cat;
210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT

Line 214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT
217: s_relation_type
218: FROM IGS_FI_FEE_AS_RATE

Line 218: FROM IGS_FI_FEE_AS_RATE

214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT
217: s_relation_type
218: FROM IGS_FI_FEE_AS_RATE
219: WHERE FEE_TYPE = cp_fee_type AND
220: fee_cal_type = cp_fee_cal_type AND
221: fee_ci_sequence_number = cp_fee_ci_seq_num AND
222: NVL(FEE_CAT, cp_fee_cat) = cp_fee_cat;

Line 225: v_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE;

221: fee_ci_sequence_number = cp_fee_ci_seq_num AND
222: NVL(FEE_CAT, cp_fee_cat) = cp_fee_cat;
223:
224: v_currency_cd igs_fi_control.currency_cd%TYPE;
225: v_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE;
226: l_ctrl_currency igs_fi_control.currency_cd%TYPE;
227:
228: BEGIN
229: OPEN cur_ctrl;