APPS.IGS_FI_SS_ACCT_PAYMENT dependencies on IGS_FI_INV_INT_ALL

Line 7: -- removed the obseleted columns of IGS_FI_INV_INT_ALL.

3: ------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --skharida 26-Jun-2006 Bug 5208136: Modified finp_decline_Optional_fee and finp_set_optional_fee_flag procedures
7: -- removed the obseleted columns of IGS_FI_INV_INT_ALL.
8: --gurprsin 6-Dec-2005 Bug 4735807, Modified the finp_calc_fees_todo method, Added a condition to skip the addition of message onto the stack as it is already added in
9: -- finp_ins_enr_fee_ass method for the case ' if no fee category is attached to the SPA.'. Otherwise a null message
10: -- will be added and shown on the SS page.
11: --gurprsin 13-Sep-2005 Bug 3765876, Modified the Cursor c_get_msg_text select statement to add userenv. language condition with application id

Line 651: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL

647: -- Update Invoice record with optional_fee_flag=>'D'(Declined)
648:
649: --Change History
650: --Who When What
651: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
652: --vvutukur 25-Nov-2002 Enh#2584986.Removed the call to igs_fi_inv_int_pkg.update_row.
653: --vvutukur 16-Sep-2002 Enh#2564643.As part of subaccount removal build,removed parameter
654: -- x_subaccount_id from the following call to igs_fi_inv_int_pkg.update_row.
655: --jbegum 20 feb 02 Enh bug # 2228910

Line 751: FROM igs_fi_inv_int_all inv ,

747:
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

Line 771: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL

767: FETCH cur_inv_int INTO l_cur_inv_int ;
768:
769: --Change History
770: --Who When What
771: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
772: --vvutukur 16-Sep-2002 Enh#2564643.As part of subaccount removal build, removed parameter
773: -- x_subaccount_id from the following call to igs_fi_inv_int_pkg.update_row.
774: --jbegum 20 feb 02 Enh bug # 2228910
775: -- Removed the source_transaction_id column from igs_fi_inv_int_pkg.update_row