APPS.IGS_FI_UPG_RETENTION dependencies on IGS_FI_INVLN_INT_ALL

Line 14: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all

10: Change History
11: Who When What
12: abshriva 4-May-2006 Bug 5178077: Modification done in PROCEDURE upg_accts
13: svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
14: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
15: shtatiko 11-DEC-2003 Bug# 3288973, Created this process
16: ***************************************************************** */
17:
18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

Line 97: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all

93: Who When What
94: abshriva 4-May-2006 Bug 5178077: Introduced igs_ge_gen_003.set_org_id
95: skharida 13-Feb-2006 APPSPERF: bug 5018036, Replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst
96: svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
97: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
98:
99: shtatiko 11-DEC-2003 Bug# 3288973, Created this process
100: ***************************************************************** */
101:

Line 124: igs_fi_invln_int_all b,

120: c.rec_account_cd ftci_rec_account_cd,
121: c.ret_gl_ccid ftci_ret_gl_ccid,
122: c.ret_account_cd ftci_ret_account_cd
123: FROM igs_fi_inv_int_all a,
124: igs_fi_invln_int_all b,
125: igs_fi_f_typ_ca_inst c,
126: igs_ca_inst ci
127: WHERE a.invoice_id = b.invoice_id
128: AND a.transaction_type = 'RETENTION'

Line 173: FROM igs_fi_invln_int_all inv

169:
170:
171: CURSOR c_invoice_details ( cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE ) IS
172: SELECT ROWID, inv.*
173: FROM igs_fi_invln_int_all inv
174: WHERE invoice_id = cp_n_invoice_id;
175: rec_invoice_details c_invoice_details%ROWTYPE;
176:
177: CURSOR c_application_details ( cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE ) IS