APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_FI_APPLICATIONS

Line 142: FROM igs_fi_applications appl,

138: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
139: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
140: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
141: SELECT SUM(appl.amount_applied) amt_appl
142: FROM igs_fi_applications appl,
143: igs_fi_inv_int_all inv
144: WHERE appl.credit_id = cp_n_credit_id
145: AND appl.invoice_id = inv.invoice_id
146: AND inv.fee_cal_type = cp_v_fee_cal_type

Line 292: FROM igs_fi_applications appl,

288: ORDER BY inv.invoice_id;
289:
290: CURSOR cur_chgadj(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
291: SELECT SUM(appl.amount_applied) amt_appl
292: FROM igs_fi_applications appl,
293: igs_fi_credits_all crd,
294: igs_fi_cr_types crt
295: WHERE appl.invoice_id = cp_n_invoice_id
296: AND appl.credit_id = crd.credit_id

Line 316: FROM igs_fi_applications appl,

312: cp_n_fee_ci_seq igs_fi_inv_int_all.fee_ci_sequence_number%TYPE) IS
313: SELECT appl.amount_applied,
314: appl.application_id,
315: appl.credit_id
316: FROM igs_fi_applications appl,
317: igs_fi_credits_all crd,
318: igs_fi_cr_types_all crt
319: WHERE appl.invoice_id = cp_n_invoice_id
320: AND appl.credit_id = crd.credit_id

Line 334: FROM igs_fi_applications appl,

330: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
331: cp_n_fee_ci_seq igs_fi_credits_all.fee_ci_sequence_number%TYPE,
332: cp_n_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
333: SELECT igs_fi_gen_007.get_sum_appl_amnt(application_id) amt_appl
334: FROM igs_fi_applications appl,
335: igs_fi_inv_int_all inv
336: WHERE appl.invoice_id = inv.invoice_id
337: AND appl.credit_id = cp_n_credit_id
338: AND inv.fee_cal_type = cp_v_fee_cal_type

Line 344: igs_fi_applications appl1

340: AND inv.transaction_type = 'WAIVER_ADJ'
341: AND appl.application_type = 'APP'
342: AND EXISTS (SELECT 'x'
343: FROM igs_fi_credits_all crd1,
344: igs_fi_applications appl1
345: WHERE appl1.credit_id = crd1.credit_id
346: AND crd1.credit_id = cp_n_credit_id
347: AND appl1.invoice_id = cp_n_invoice_id
348: AND appl1.application_type = 'UNAPP'

Line 1054: FROM igs_fi_applications

1050: AND unapplied_amount > 0;
1051:
1052: CURSOR cur_app(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
1053: SELECT invoice_id
1054: FROM igs_fi_applications
1055: WHERE credit_id = cp_n_credit_id
1056: AND application_type = 'UNAPP'
1057: ORDER BY application_id;
1058: