DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_SUB_ER_RT

Line 2881: CURSOR cur_sub_elm_rng_rates (cp_n_sub_er_id igs_fi_sub_er_rt.sub_er_id%TYPE) IS

2877: WHERE er_id = cp_n_er_id
2878: ORDER BY sub_lower_range;
2879:
2880: -- Cursor to find all rates defined under sub element range found in above cursor.
2881: CURSOR cur_sub_elm_rng_rates (cp_n_sub_er_id igs_fi_sub_er_rt.sub_er_id%TYPE) IS
2882: SELECT far.*
2883: FROM igs_fi_sub_er_rt ser,
2884: igs_fi_fee_as_rate far
2885: WHERE ser.sub_er_id = cp_n_sub_er_id

Line 2883: FROM igs_fi_sub_er_rt ser,

2879:
2880: -- Cursor to find all rates defined under sub element range found in above cursor.
2881: CURSOR cur_sub_elm_rng_rates (cp_n_sub_er_id igs_fi_sub_er_rt.sub_er_id%TYPE) IS
2882: SELECT far.*
2883: FROM igs_fi_sub_er_rt ser,
2884: igs_fi_fee_as_rate far
2885: WHERE ser.sub_er_id = cp_n_sub_er_id
2886: AND far.far_id = ser.far_id
2887: AND ser.logical_delete_date IS NULL