APPS.CST_UPD_GIR_MTA_WTA dependencies on WIP_TRANSACTION_ACCOUNTS

Line 469: wip_transaction_accounts wta

465: wta.rowid,
466: wta.wip_sub_ledger_id,
467: sl.gl_sl_link_id
468: from cst_gl_summary_links_temp sl,
469: wip_transaction_accounts wta
470: where wta.gl_batch_id = sl.gl_batch_id
471: and wta.reference_account = sl.reference_account
472: and sl.gl_currency_code = nvl(wta.currency_code, sl.ledger_currency_code)
473:

Line 486: TYPE wip_sub_ledger_id_type IS TABLE OF wip_transaction_accounts.wip_sub_ledger_id%TYPE;

482: and R.gl_sl_link_id = wta.gl_sl_link_id
483: and R.reference_3 is null )) --Support Flexible Logic
484: order by sl.gl_sl_link_id;
485:
486: TYPE wip_sub_ledger_id_type IS TABLE OF wip_transaction_accounts.wip_sub_ledger_id%TYPE;
487:
488: wta_rowid_tab gir_rowid_type;
489: wip_sub_ledger_id_tab wip_sub_ledger_id_type;
490:

Line 696: update wip_transaction_accounts wta

692: END IF;
693:
694: l_stmnt_num := 80;
695: FORALL i in 1..wta_rowid_tab.count
696: update wip_transaction_accounts wta
697: set wta.gl_sl_link_id = gl_sl_link_id_tab(i)
698: where wta.rowid = wta_rowid_tab(i);
699:
700: debug(' L'||l_count||': Updated '||SQL%ROWCOUNT||' rows in WTA');

Line 714: AND xdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'

710: xdl.ae_header_id,
711: xdl.ae_line_num
712: from xla_distribution_links xdl
713: where XDL.application_id =707 /*Added for bug 16217359*/
714: AND xdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'
715: and xdl.source_distribution_id_num_1 = wip_sub_ledger_id_tab(i));
716:
717: debug(' L'||l_count||': Updated '||SQL%ROWCOUNT||' rows in XAL');
718: