APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_SUB_ELM_RNG

Line 2876: FROM igs_fi_sub_elm_rng

2872:
2873: -- Cursor to find all Sub Element ranges defined for the input parameter
2874: CURSOR cur_sub_elm_ranges (cp_n_er_id igs_fi_elm_range.er_id%TYPE) IS
2875: SELECT *
2876: FROM igs_fi_sub_elm_rng
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.

Line 2916: l_n_previous_upper igs_fi_sub_elm_rng.sub_upper_range%TYPE;

2912: l_rec_global_rates c_elm_rng_rates%ROWTYPE;
2913: l_n_count NUMBER; -- Used like an index variable when a new record in added to the plsql table tbl_fai_unit_dtls
2914: l_v_party_number hz_parties.party_number%TYPE := NULL;
2915: l_n_loop_subelm_rng NUMBER;
2916: l_n_previous_upper igs_fi_sub_elm_rng.sub_upper_range%TYPE;
2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
2919: lv_cntrct_rt_apply BOOLEAN;
2920: l_n_summed_chg_elm igs_fi_fee_as_items.chg_elements%TYPE;

Line 3545: fnd_message.set_name ( 'IGS', 'IGS_FI_SUB_ELM_RNG_MATCH');

3541: LOOP
3542: IF (l_n_loop_subelm_rng = 0) THEN
3543: IF (p_v_trace_on = 'Y') THEN
3544: fnd_file.new_line(fnd_file.log);
3545: fnd_message.set_name ( 'IGS', 'IGS_FI_SUB_ELM_RNG_MATCH');
3546: fnd_file.put_line (fnd_file.log, fnd_message.get);
3547: fnd_file.new_line(fnd_file.log);
3548: END IF;
3549: l_n_loop_subelm_rng := 1;