[Home] [Help]
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;
1546: l_ar_source_table ar_distributions_all.source_table%TYPE;
1547: l_ar_source_type ar_distributions_all.source_type%TYPE;
1548: l_reimb_act_select VARCHAR2(100) ;
1861: gl_code_combinations gcc,
1862: fv_fund_parameters ffp,
1863: fv_treasury_symbols fts,
1864: xla_ae_lines xal,
1865: xla_ae_headers xah,
1866: xla_distribution_links xdl,
1867: gl_import_references gir
1868: WHERE gjl.ledger_id = :sob_id
1869: AND gjl.status = :status
5747: SELECT xd.source_distribution_id_num_1 transaction_id,
5748: xte.transaction_number
5749: FROM gl_import_references gli,
5750: xla_ae_lines xl ,
5751: xla_ae_headers xh ,
5752: xla_distribution_links xd,
5753: xla_transaction_entities xte
5754: WHERE gli.je_batch_id = p_je_batch_id
5755: AND gli.je_header_id = p_je_header_id
5909: SELECT event_id
5910: INTO l_sla_event_id
5911: FROM gl_import_references gli,
5912: xla_ae_lines l,
5913: xla_ae_headers h
5914: WHERE gli.je_batch_id = p_je_batch_id
5915: AND gli.je_header_id = p_je_header_id
5916: AND gli.je_line_num = p_je_line_num
5917: AND l.gl_sl_link_id = gli.gl_sl_link_id
5922:
5923: FOR sla_event in event_lines_cur LOOP
5924:
5925: l_acct_select := 'SELECT SUBSTR(ffv.compiled_value_attributes,5,1)
5926: FROM xla_ae_headers xh,
5927: xla_ae_lines xl,
5928: gl_code_combinations gcc,
5929: fnd_flex_values ffv
5930: WHERE xh.event_id = '||sla_event.event_id||