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_BILL_EXTRACT dependencies on IGS_FI_FEE_TYPE

Line 693: CURSOR cur_fee_type(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS

689: l_bill_desc igs_fi_bill_pln_crd.bill_desc%TYPE;
690: l_c_rec_installed igs_fi_control.rec_installed%TYPE;
691:
692: -- Bug #3813498 To get system fee type and fee class associated with the fee_type
693: CURSOR cur_fee_type(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
694: SELECT s_fee_type, fee_class
695: FROM igs_fi_fee_type ft
696: WHERE fee_type = cp_fee_type;
697:

Line 695: FROM igs_fi_fee_type ft

691:
692: -- Bug #3813498 To get system fee type and fee class associated with the fee_type
693: CURSOR cur_fee_type(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
694: SELECT s_fee_type, fee_class
695: FROM igs_fi_fee_type ft
696: WHERE fee_type = cp_fee_type;
697:
698: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
699: l_v_fee_class igs_fi_fee_type.fee_class%TYPE;

Line 698: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;

694: SELECT s_fee_type, fee_class
695: FROM igs_fi_fee_type ft
696: WHERE fee_type = cp_fee_type;
697:
698: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
699: l_v_fee_class igs_fi_fee_type.fee_class%TYPE;
700: l_v_fee_class_meaning igs_lookup_values.meaning%TYPE;
701:
702: CURSOR cur_min_inv_dt IS

Line 699: l_v_fee_class igs_fi_fee_type.fee_class%TYPE;

695: FROM igs_fi_fee_type ft
696: WHERE fee_type = cp_fee_type;
697:
698: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
699: l_v_fee_class igs_fi_fee_type.fee_class%TYPE;
700: l_v_fee_class_meaning igs_lookup_values.meaning%TYPE;
701:
702: CURSOR cur_min_inv_dt IS
703: SELECT MIN(invoice_creation_date)