APPS.CST_UPD_GIR_MTA_WTA dependencies on MTL_TRANSACTION_ACCOUNTS

Line 43: FROM mtl_transaction_accounts m,

39:
40: CURSOR cu_xla_line IS
41: SELECT l.rowid,
42: m.gl_sl_link_id
43: FROM mtl_transaction_accounts m,
44: cst_lists_temp c,
45: xla_distribution_links lk,
46: xla_ae_lines l
47: WHERE lk.application_id = 707

Line 48: AND lk.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

44: cst_lists_temp c,
45: xla_distribution_links lk,
46: xla_ae_lines l
47: WHERE lk.application_id = 707
48: AND lk.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
49: AND lk.source_distribution_id_num_1 = c.number_1
50: AND lk.application_id = 707
51: AND lk.ae_header_id = l.ae_header_id
52: AND lk.ae_line_num = l.ae_line_num

Line 108: UPDATE mtl_transaction_accounts

104:
105: debug(' Update MTA.GL_SL_LINK_ID for MTA');
106:
107: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
108: UPDATE mtl_transaction_accounts
109: SET gl_sl_link_id = gl_sl_link_id_tab(i)
110: WHERE gl_batch_id = gl_batch_id_tab(i)
111: AND reference_account = ccid_tab(i);
112:

Line 127: FROM mtl_transaction_accounts

123: inv_sub_ledger_id,
124: transaction_id,
125: reference_account,
126: NULL
127: FROM mtl_transaction_accounts
128: WHERE gl_batch_id = gl_batch_id_tab(i)
129: AND reference_account = ccid_tab(i);
130: END IF;
131: