APPS.CST_UPD_GIR_MTA_WTA dependencies on WIP_TRANSACTION_ACCOUNTS

Line 190: FROM wip_transaction_accounts m,

186:
187: CURSOR cu_xla_line IS
188: SELECT l.rowid,
189: m.gl_sl_link_id
190: FROM wip_transaction_accounts m,
191: cst_lists_temp c,
192: xla_distribution_links lk,
193: xla_ae_lines l
194: WHERE lk.application_id = 707

Line 195: AND lk.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'

191: cst_lists_temp c,
192: xla_distribution_links lk,
193: xla_ae_lines l
194: WHERE lk.application_id = 707
195: AND lk.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'
196: AND lk.source_distribution_id_num_1 = c.number_1
197: AND lk.application_id = 707
198: AND lk.ae_header_id = l.ae_header_id
199: AND lk.ae_line_num = l.ae_line_num

Line 258: UPDATE wip_transaction_accounts

254:
255: debug(' Update WTA.GL_SL_LINK_ID for WTA');
256:
257: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
258: UPDATE wip_transaction_accounts
259: SET gl_sl_link_id = gl_sl_link_id_tab(i)
260: WHERE gl_batch_id = gl_batch_id_tab(i)
261: AND reference_account = ccid_tab(i);
262:

Line 277: FROM wip_transaction_accounts

273: wip_sub_ledger_id,
274: transaction_id,
275: reference_account,
276: NULL
277: FROM wip_transaction_accounts
278: WHERE gl_batch_id = gl_batch_id_tab(i)
279: AND reference_account = ccid_tab(i);
280: END IF;
281: