APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_FI_INV_INT

Line 715: FROM igs_fi_inv_int_all

711: WHERE order_number = cp_order_number;
712:
713: CURSOR c_inv(cp_inv igs_as_order_hdr.invoice_id%TYPE) IS
714: SELECT invoice_amount_due
715: FROM igs_fi_inv_int_all
716: WHERE invoice_id = cp_inv;
717:
718:
719: v_ord_rec c_ord%ROWTYPE;

Line 753: CURSOR c_igs_fi_invln(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

749: l_v_currency igs_fi_control_all.currency_cd%TYPE;
750: l_v_curr_desc fnd_currencies_tl.NAME%TYPE;
751: l_v_message_name fnd_new_messages.message_name%TYPE;
752: --CURSOR ADDED FOR CHECKING WHETHER A RECORD ALREADY EXISTS FOR THE INVOICE ID GIVEN.
753: CURSOR c_igs_fi_invln(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
754: SELECT '1'
755: FROM igs_fi_invln_int_all
756: WHERE invoice_id = cp_invoice_id
757: AND NVL(error_account,'N') = 'Y'

Line 1158: l_inv_amt_due igs_fi_inv_int_all.invoice_amount_due%TYPE;

1154: l_cr_gl_ccid igs_fi_cr_activities.cr_gl_ccid%TYPE;
1155: l_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
1156: l_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
1157: l_unapp_amount igs_fi_credits_all.unapplied_amount%TYPE;
1158: l_inv_amt_due igs_fi_inv_int_all.invoice_amount_due%TYPE;
1159: BEGIN
1160: igs_fi_gen_007.create_application (
1161: p_application_id => p_application_id,
1162: p_credit_id => p_credit_id,