APPS.CST_UPD_GIR_MTA_WTA dependencies on XLA_DISTRIBUTION_LINKS

Line 369: in (select /*+ index(xdl xla_distribution_links_n1) */

365: set xal.gl_sl_link_id = gl_sl_link_id_tab(i)
366: where xal.application_id = 707
367: and xal.gl_sl_link_table = 'MTA'
368: and (xal.ae_header_id, xal.ae_line_num)
369: in (select /*+ index(xdl xla_distribution_links_n1) */
370: xdl.ae_header_id,
371: xdl.ae_line_num
372: from xla_distribution_links xdl
373: where XDL.application_id = 707 /*Added for bug 16217359 */

Line 372: from xla_distribution_links xdl

368: and (xal.ae_header_id, xal.ae_line_num)
369: in (select /*+ index(xdl xla_distribution_links_n1) */
370: xdl.ae_header_id,
371: xdl.ae_line_num
372: from xla_distribution_links xdl
373: where XDL.application_id = 707 /*Added for bug 16217359 */
374: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
375: and xdl.source_distribution_id_num_1 = inv_sub_ledger_id_tab(i));
376:

Line 709: in (select /*+ index(xdl xla_distribution_links_n1) */

705: set xal.gl_sl_link_id = gl_sl_link_id_tab(i)
706: where xal.application_id = 707
707: and xal.gl_sl_link_table = 'WTA'
708: and (xal.ae_header_id, xal.ae_line_num)
709: in (select /*+ index(xdl xla_distribution_links_n1) */
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*/

Line 712: from xla_distribution_links xdl

708: and (xal.ae_header_id, xal.ae_line_num)
709: in (select /*+ index(xdl xla_distribution_links_n1) */
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: