APPS.IGS_FI_GEN_GL dependencies on IGS_FI_INV_INT

Line 354: CURSOR cur_inv (cp_n_invoice_id IN igs_fi_inv_int.invoice_id%TYPE) IS

350: Who When What
351: ******************************************************************/
352:
353:
354: CURSOR cur_inv (cp_n_invoice_id IN igs_fi_inv_int.invoice_id%TYPE) IS
355: SELECT gl_date
356: FROM igs_fi_invln_int_all
357: WHERE gl_date IS NOT NULL
358: AND invoice_id = cp_n_invoice_id;

Line 425: CURSOR cur_app_crd (cp_n_invoice_id IN igs_fi_inv_int.invoice_id%TYPE) IS

421: ******************************************************************/
422:
423: -- Below 2 Cursors to check if negative charge adjustment exists in applications table for the invoice_id
424:
425: CURSOR cur_app_crd (cp_n_invoice_id IN igs_fi_inv_int.invoice_id%TYPE) IS
426: SELECT credit_id
427: FROM igs_fi_applications
428: WHERE invoice_id = cp_n_invoice_id
429: AND application_type = 'APP';