eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_ELM_RANGE

Line 1588: cp_n_range_number igs_fi_elm_range.range_number%TYPE,

1584: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1585: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1586: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
1587: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
1588: cp_n_range_number igs_fi_elm_range.range_number%TYPE,
1589: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS
1590: SELECT err.rate_number,
1591: far.order_of_precedence,
1592: far.chg_rate,

Line 1589: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS

1585: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1586: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
1587: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
1588: cp_n_range_number igs_fi_elm_range.range_number%TYPE,
1589: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS
1590: SELECT err.rate_number,
1591: far.order_of_precedence,
1592: far.chg_rate,
1593: far.govt_hecs_payment_option,

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 2839: FROM igs_fi_elm_range

2835: range_number,
2836: lower_range,
2837: upper_range,
2838: s_chg_method_type override_chg_method_type -- Override charge method at element range level
2839: FROM igs_fi_elm_range
2840: WHERE fee_type = cp_v_fee_type
2841: AND fee_cal_Type = cp_v_fee_cal_type
2842: AND fee_ci_sequence_number = cp_n_ci_seq_number
2843: AND (fee_cat IS NULL OR fee_cat = cp_v_fee_cat)

Line 2852: cp_n_range_number igs_fi_elm_range.range_number%TYPE,

2848: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2850: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
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

Line 2853: cp_v_relation_type igs_fi_elm_range.s_relation_type%TYPE) IS

2849: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
2850: cp_n_ci_seq_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
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

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

Line 2874: CURSOR cur_sub_elm_ranges (cp_n_er_id igs_fi_elm_range.er_id%TYPE) IS

2870: AND far.logical_delete_dt IS NULL
2871: ORDER BY far.order_of_precedence ASC;
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;