DBA Data[Home] [Help]

APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_INV_INT_ALL

Line 687: igs_fi_inv_int_all inv

683: CURSOR cur_inv (cp_d_gl_date_start IN igs_fi_posting_int_all.accounting_date%TYPE,
684: cp_d_gl_date_end IN igs_fi_posting_int_all.accounting_date%TYPE ) IS
685: SELECT invln.rowid row_id, inv.invoice_creation_date, inv.currency_cd, invln.*
686: FROM igs_fi_invln_int_all invln,
687: igs_fi_inv_int_all inv
688: WHERE invln.gl_date IS NOT NULL
689: AND TRUNC(invln.gl_date) BETWEEN TRUNC(cp_d_gl_date_start) AND TRUNC(cp_d_gl_date_end)
690: AND invln.posting_id IS NULL
691: AND invln.posting_control_id IS NULL