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.IGF_SP_GEN_001 dependencies on IGS_FI_APPLICATIONS

Line 137: FROM igs_fi_applications appl,

133:
134: CURSOR cur_neg_chg_adj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE)
135: IS
136: SELECT appl.amount_applied AS amount_applied
137: FROM igs_fi_applications appl,
138: igs_fi_credits_all crd,
139: igs_fi_cr_types_all cr
140: WHERE appl.invoice_id = cp_n_invoice_id
141: AND appl.application_type = 'APP'

Line 151: FROM igs_fi_applications appl,

147: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
148: cp_n_fee_seq_number IN igs_ca_inst_all.sequence_number%TYPE)
149: IS
150: SELECT igs_fi_gen_007.get_sum_appl_amnt (appl.application_id) amount_applied , application_id
151: FROM igs_fi_applications appl,
152: igs_fi_credits_all crd,
153: igs_fi_cr_types_all cr
154: WHERE appl.invoice_id = cp_n_invoice_id
155: AND appl.application_type = 'APP'

Line 171: FROM igs_fi_applications appl,

167: cp_n_ld_seq_number IN igs_ca_inst.sequence_number%TYPE,
168: cp_v_fund_code IN igf_aw_fund_cat_all.fund_code%TYPE)
169: IS
170: SELECT appl.amount_applied AS amount_applied, appl.credit_id as credit_id
171: FROM igs_fi_applications appl,
172: igs_fi_credits_all crd,
173: igs_fi_cr_types_all cr
174: WHERE appl.invoice_id = cp_n_invoice_id
175: AND appl.application_type = 'APP'