APPS.ARP_XLA_UPGRADE dependencies on GL_IMPORT_REFERENCES

Line 3111: --{BUG#4748251 - Update gl_import_references gl_sl_link_id, gl_sl_link_table

3107: RAISE;
3108:
3109: END UPGRADE_ADJUSTMENTS;
3110:
3111: --{BUG#4748251 - Update gl_import_references gl_sl_link_id, gl_sl_link_table
3112: PROCEDURE update_gl_sla_link(
3113: l_table_owner IN VARCHAR2,
3114: l_table_name IN VARCHAR2,
3115: l_script_name IN VARCHAR2,

Line 3189: -- Needed this due to GL_IMPORT_REFERENCES reference columns data model for

3185:
3186: -- bug 13626520 : Update gl_sl_link_id for cash basis accounting >>>
3187: -- This will update gl_sl_link_id for cash basis accounting of receipt.
3188: -- Added 3 update statements for CRH, RA, CBD
3189: -- Needed this due to GL_IMPORT_REFERENCES reference columns data model for
3190: -- cash basis accounting. This part should run only if any upgraded ledger_id
3191: -- has cash basis accounting method
3192:
3193: begin

Line 3216: update /*+ rowid(gir) */ gl_import_references gir

3212: -- Update gl_sl_link_id for AR_CASH_RECEIPT_HISTORY_ALL data
3213:
3214: If (l_accounting_method = 'CASH') Then
3215:
3216: update /*+ rowid(gir) */ gl_import_references gir
3217: set gir.gl_sl_link_id = (select min(xal.gl_sl_link_id)
3218: from xla_ae_lines xal,
3219: xla_ae_headers xah,
3220: xla_transaction_entities_upg xte,

Line 3267: update /*+ rowid(gir) */ gl_import_references gir

3263: and gir.gl_sl_link_id is null;
3264:
3265: -- Update gl_sl_link_id for AR_RECEIVABLE_APPLICATIONS_ALL UNAPP data
3266:
3267: update /*+ rowid(gir) */ gl_import_references gir
3268: set gir.gl_sl_link_id = (select min(xal.gl_sl_link_id)
3269: from xla_ae_lines xal,
3270: xla_ae_headers xah,
3271: xla_transaction_entities_upg xte,

Line 3320: GL_IMPORT_REFERENCES GIMP

3316:
3317: -- Update gl_sl_link_id for AR_CASH_BASIS_DISTS_ALL data
3318:
3319: UPDATE /*+ rowid(gimp) */
3320: GL_IMPORT_REFERENCES GIMP
3321: SET
3322: (gl_sl_link_id,
3323: gl_sl_link_table) =
3324: (SELECT /*+

Line 3374: GL_IMPORT_REFERENCES GIMP

3370: -- Added for bug 6673937 ( pref. issue)
3371: -- Combined the bulk select and update under single go
3372:
3373: UPDATE /*+ rowid(gimp) */
3374: GL_IMPORT_REFERENCES GIMP
3375: SET
3376: (gl_sl_link_id,
3377: gl_sl_link_table) =
3378: (SELECT /*+