APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_INV_INT_ALL

Line 6: --skharida 26-Jun-2006 Bug#5208136 - Modified bill_the_person procedure , removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL

2: /* $Header: IGSFI61B.pls 120.16 2006/06/27 14:15:06 skharida ship $ */
3: ------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --skharida 26-Jun-2006 Bug#5208136 - Modified bill_the_person procedure , removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL
7: --sapanigr 19-Jun-2006 Bug 5134985 - Modified bill_the_person procedure. Date of first bill for student changed from null.
8: --abshriva 8-Jun-2006 Bug 5178298 Invalid Value Message in Log File: Modified the messages
9: --abshriva 12-May-2006 Bug#5217319:- Amount precision change in bill_the_person,create_payplan_bills
10: --sapanigr 24-Feb-2006 Bug#5018036 - Removed cursor cur_person_number in bill_the_person procedure and replaced it by function call.

Line 249: --skharida 26-Jun-2006 Bug# 5208136 - Removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL

245: ) IS
246: ------------------------------------------------------------------
247: --Change History:
248: --Who When What
249: --skharida 26-Jun-2006 Bug# 5208136 - Removed the usage of obsoleted columns of the table IGS_FI_INV_INT_ALL
250: --sapanigr 19-Jun-2006 Bug 5134985 - First bill for a student modified to show start date as earlier of first charge or credit date.
251: -- Earlier this field was being left null.
252: --abshriva 8-Jun-2006 Bug 5178298 Invalid Value Message in Log File: Added proper messages
253: --

Line 704: FROM igs_fi_inv_int_all

700: l_v_fee_class_meaning igs_lookup_values.meaning%TYPE;
701:
702: CURSOR cur_min_inv_dt IS
703: SELECT MIN(invoice_creation_date)
704: FROM igs_fi_inv_int_all
705: WHERE person_id = p_n_person_id;
706:
707: CURSOR cur_min_crd_dt IS
708: SELECT MIN(effective_date)

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

1130: LOOP
1131:
1132: --Change History
1133: --Who When What
1134: --skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL
1135: --shtatiko 21-AUG-2003 Bug@ 3106262, Added reversal_gl_date column to igs_fi_inv_int_pkg.update_row
1136: --jbegum 24-Sep-02 Enh Bug#2564643
1137: -- Removed the subaccount_id parameter from call to igs_fi_inv_int_pkg.update_row
1138: --jbegum 20 feb 02 Enh bug # 2228910