DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_ELM_RANGE_RT

Line 1612: FROM igs_fi_elm_range_rt err,

1608: far.unit_mode,
1609: far.unit_cd,
1610: far.unit_version_number,
1611: far.unit_level
1612: FROM igs_fi_elm_range_rt err,
1613: igs_fi_fee_as_rate far
1614: WHERE far.fee_type = err.fee_type
1615: AND far.fee_cal_type = err.fee_cal_type
1616: AND far.fee_ci_sequence_number = err.fee_ci_sequence_number

Line 2855: FROM igs_fi_elm_range_rt err,

2851: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
2852: cp_n_range_number igs_fi_elm_range.range_number%TYPE,
2853: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS
2854: SELECT far.*
2855: FROM igs_fi_elm_range_rt err,
2856: igs_fi_fee_as_rate far
2857: WHERE far.fee_type = err.fee_type
2858: AND far.fee_cal_type = err.fee_cal_type
2859: AND far.fee_ci_sequence_number = err.fee_ci_sequence_number