APPS.CST_UPD_GIR_MTA_WTA dependencies on XLA_AE_LINES

Line 46: xla_ae_lines l

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
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

Line 143: UPDATE xla_ae_lines

139: FETCH cu_xla_line BULK COLLECT INTO
140: xline_rowid_tab,
141: xl_link_id_tab ;
142: FORALL i IN xline_rowid_tab.FIRST .. xline_rowid_tab.LAST
143: UPDATE xla_ae_lines
144: SET gl_sl_link_id = xl_link_id_tab(i)
145: WHERE rowid = xline_rowid_tab(i);
146: CLOSE cu_xla_line;
147: END IF;

Line 193: xla_ae_lines l

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
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

Line 293: UPDATE xla_ae_lines

289: FETCH cu_xla_line BULK COLLECT INTO
290: xline_rowid_tab,
291: xl_link_id_tab ;
292: FORALL i IN xline_rowid_tab.FIRST .. xline_rowid_tab.LAST
293: UPDATE xla_ae_lines
294: SET gl_sl_link_id = xl_link_id_tab(i)
295: WHERE rowid = xline_rowid_tab(i);
296: CLOSE cu_xla_line;
297: END IF;