APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_INV_INT

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

Line 1022: FROM igs_fi_inv_int inv, igs_fi_invln_int invln

1018:
1019: --Cursor to fetch the invoice number for the passed invoice_id
1020: CURSOR cur_charge (cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1021: SELECT inv.invoice_number
1022: FROM igs_fi_inv_int inv, igs_fi_invln_int invln
1023: WHERE invln.invoice_lines_id = cp_transaction_id
1024: AND inv.invoice_id = invln.invoice_id;
1025:
1026: --Cursor to fetch the credit number for the passed credit_id

Line 1040: igs_fi_inv_int inv

1036: SELECT crd.credit_number,
1037: inv.invoice_number
1038: FROM igs_fi_applications app,
1039: igs_fi_credits crd,
1040: igs_fi_inv_int inv
1041: WHERE application_id = cp_transaction_id
1042: AND app.credit_id = crd.credit_id
1043: AND app.invoice_id = inv.invoice_id;
1044:

Line 1046: l_v_invoice_number igs_fi_inv_int.invoice_number%TYPE;

1042: AND app.credit_id = crd.credit_id
1043: AND app.invoice_id = inv.invoice_id;
1044:
1045: l_v_comments ra_interface_lines_all.comments%TYPE := NULL;
1046: l_v_invoice_number igs_fi_inv_int.invoice_number%TYPE;
1047: l_v_credit_number igs_fi_credits.credit_number%TYPE;
1048:
1049: BEGIN
1050: -- Setup the comments with the passes transaction types meaning and colon :