APPS.IGS_FI_GEN_GL dependencies on IGS_FI_INVLN_INT_ALL

Line 190: FROM igs_fi_invln_int_all invln

186: --Cursor to check unposted transactions in charges table.
187: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
188: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
189: SELECT 'Y'
190: FROM igs_fi_invln_int_all invln
191: WHERE invln.gl_date IS NOT NULL
192: AND TRUNC(invln.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
193: AND invln.posting_id IS NULL
194: AND invln.posting_control_id IS NULL;

Line 356: FROM igs_fi_invln_int_all

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;
359:
360:

Line 367: l_d_chg_gl_date igs_fi_invln_int_all.gl_date%TYPE := NULL;

363: FROM igs_fi_credits_all
364: WHERE gl_date IS NOT NULL
365: AND credit_id = cp_n_credit_id;
366:
367: l_d_chg_gl_date igs_fi_invln_int_all.gl_date%TYPE := NULL;
368: l_d_crd_gl_date igs_fi_credits_all.gl_date%TYPE := NULL;
369:
370: BEGIN
371: