APPS.IGS_FI_UPG_RETENTION dependencies on IGS_FI_APPLICATIONS

Line 154: FROM igs_fi_applications app,

150: ftci.ret_gl_ccid ftci_ret_gl_ccid,
151: ftci.ret_account_cd ftci_ret_account_cd,
152: ci.start_dt,
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

Line 179: FROM igs_fi_applications app

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
178: SELECT ROWID, app.*
179: FROM igs_fi_applications app
180: WHERE invoice_id = cp_n_invoice_id;
181:
182: CURSOR c_cr_act_details ( cp_n_credit_id igs_fi_credits_all.credit_id%TYPE ) IS
183: SELECT ROWID, crd.*

Line 594: igs_fi_applications_pkg.update_row(x_rowid => rec_application_details.rowid,

590:
591: IF l_b_upd THEN
592:
593: l_b_upgrade_done := TRUE;
594: igs_fi_applications_pkg.update_row(x_rowid => rec_application_details.rowid,
595: x_application_id => rec_application_details.application_id,
596: x_application_type => rec_application_details.application_type,
597: x_invoice_id => rec_application_details.invoice_id,
598: x_credit_id => rec_application_details.credit_id,

Line 623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP

619:
620: -- Check if this Application Record has been posted to GL Interface or Posting Interface
621: IF rec_application_details.posting_control_id IS NOT NULL THEN
622: IF l_v_rec_installed = 'Y' THEN
623: FOR rec_gl_interface IN c_gl_interface( rec_application_details.application_id, 'IGS_FI_APPLICATIONS' ) LOOP
624: IF rec_application_details.application_type = 'APP'
625: AND rec_gl_interface.accounted_cr IS NOT NULL
626: AND rec_gl_interface.code_combination_id IS NULL THEN
627: UPDATE gl_interface