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.

[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_FEE_STR_STAT

Line 4561: igs_fi_fee_str_stat fss

4557:
4558: CURSOR c_fcci_fss ( cp_effective_dt DATE) IS
4559: SELECT fcci.fee_cat
4560: FROM igs_fi_f_cat_ca_inst fcci,
4561: igs_fi_fee_str_stat fss
4562: WHERE fcci.fee_cat = p_fee_category
4563: AND (
4564: -- In Predictive, Select only when Effective Date (i.e., SYSDATE) is less than FCCI Start Date Alias Value.
4565: ( g_c_predictive_ind = 'Y' AND

Line 7794: IGS_FI_FEE_STR_STAT fss,

7790: fcci.end_dai_sequence_number,
7791: ci.start_dt,
7792: ci.end_dt
7793: FROM IGS_FI_F_CAT_CA_INST fcci,
7794: IGS_FI_FEE_STR_STAT fss,
7795: igs_ca_inst_all ci
7796: WHERE fcci.FEE_CAT = p_fee_cat AND
7797: (p_fee_cal_type IS NULL OR fcci.fee_cal_type = p_fee_cal_type) AND
7798: (p_fee_ci_sequence_num IS NULL OR

Line 7888: igs_fi_fee_str_stat fss,

7884: fcflv.elm_rng_order_name,
7885: fcflv.scope_rul_sequence_num,
7886: fcflv.max_chg_elements
7887: FROM igs_fi_f_cat_fee_lbl_v fcflv,
7888: igs_fi_fee_str_stat fss,
7889: igs_fi_fee_type_all ft
7890: WHERE fcflv.fee_cat = cp_fee_cat AND
7891: fcflv.fee_cal_type = cp_fee_cal_type AND
7892: fcflv.fee_ci_sequence_number = cp_fee_ci_sequence_number AND