APPS.IGS_FI_SS_ACCT_PAYMENT dependencies on IGS_FI_INVLN_INT

Line 547: FROM IGS_FI_INVLN_INT

543: WHERE invoice_id = cp_invoice_id;
544: -- Cursor for fetching Invoice Lines details
545: CURSOR cur_invln(p_invoice_id IGS_FI_INV_INT.Invoice_Id%TYPE) IS
546: SELECT *
547: FROM IGS_FI_INVLN_INT
548: WHERE invoice_id = p_invoice_id;
549: l_chg_rec Igs_Fi_Charges_Api_Pvt.Header_Rec_Type;
550: l_chg_line_tbl Igs_Fi_Charges_Api_Pvt.Line_Tbl_Type;
551: l_line_tbl Igs_Fi_Charges_Api_Pvt.Line_Id_Tbl_Type;

Line 737: Modified cursor cur_opt_fees - included join with igs_fi_invln_int_all

733: vvutukur 04-Dec-2003 Bug#3249288.Modified cursor cur_opt_fees to select invoice records having
734: optional fee flag as 'O' without need to look at the value of optional_payment_ind
735: at fee type set up level.
736: pathipat 04-Jun-2003 Enh 2831584 - SS Enhancements Build
737: Modified cursor cur_opt_fees - included join with igs_fi_invln_int_all
738: vvutukur 25-Nov-2002 Enh#2584986.Passed NULL to the newly added parameter x_reversal_gl_date in the call to
739: igs_fi_inv_int_pkg.update_row.
740: vvutukur 16-Sep-2002 Enh#2564643.Removed the references to subaccount_id.ie., from
741: parameters list p_subaccount_id,from cursor cur_opt_fees and from the

Line 752: igs_fi_invln_int_all invln

748: -- Cursor to fetch all the Optional fees which are not Declined
749: CURSOR cur_opt_fees IS
750: SELECT inv.invoice_id
751: FROM igs_fi_inv_int_all inv ,
752: igs_fi_invln_int_all invln
753: WHERE invln.invoice_id = inv.invoice_id
754: AND NVL(invln.error_account,'N') = 'N'
755: AND inv.person_id = p_person_id
756: AND inv.optional_fee_flag ='O';