[Home] [Help]
91: Known limitations,enhancements,remarks:
92: Change History
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
103: CURSOR c_sys_opt_rec_acct IS
104: SELECT rec_installed, rec_gl_ccid, rec_account_cd, accounting_method
105: FROM igs_fi_control_all;
106:
107: -- Bug 5018036, SQL ID 14794917: replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst
108: CURSOR c_upd_charges IS
109: SELECT a.invoice_id,
110: a.fee_type,
111: a.fee_cal_type,
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'
129: AND b.error_account = 'Y'
130: AND a.fee_type = c.fee_type
133: And ci.cal_type=c.fee_cal_type
134: And ci.sequence_number = c.fee_ci_sequence_number
135: ORDER BY a.fee_type, a.fee_cal_type, a.fee_ci_sequence_number;
136:
137: -- Bug 5018036: Instead using igs_fi_f_typ_ca_inst_lkp_v joined igs_fi_f_typ_ca_inst and igs_ca_inst
138: CURSOR c_upd_applications IS
139: SELECT app.invoice_id ,
140: app.application_id ,
141: inv.fee_type ,
153: ci.end_dt
154: FROM igs_fi_applications app,
155: igs_fi_inv_int_all inv,
156: igs_fi_f_typ_ca_inst ftci,
157: igs_ca_inst ci
158: WHERE app.invoice_id = inv.invoice_id
159: AND inv.transaction_type = 'RETENTION'
160: AND inv.fee_type = ftci.fee_type
161: AND inv.fee_cal_type = ftci.fee_cal_type