APPS.IGS_FI_GEN_GL dependencies on IGS_FI_APPLICATIONS

Line 168: FROM igs_fi_applications appl

164: CURSOR cur_appl(cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
165: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
166:
167: SELECT 'Y'
168: FROM igs_fi_applications appl
169: WHERE appl.gl_date IS NOT NULL
170: AND TRUNC(appl.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
171: AND appl.posting_id IS NULL
172: AND appl.posting_control_id IS NULL;

Line 427: FROM igs_fi_applications

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';
430:
431: