DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_F_CAT_FEE_LBL_V

Line 5749: FROM igs_fi_f_cat_fee_lbl_v

5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5746: cp_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5747: cp_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE) IS
5748: SELECT s_chg_method_type, elm_rng_order_name
5749: FROM igs_fi_f_cat_fee_lbl_v
5750: WHERE fee_cat = cp_fee_cat
5751: AND fee_type = cp_fee_type
5752: AND fee_cal_type = cp_fee_cal_type
5753: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;

Line 7887: FROM igs_fi_f_cat_fee_lbl_v fcflv,

7883: 'CURRENT' source,
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