[Home] [Help]
1343: BEGIN
1344:
1345: SELECT DISTINCT xll.party_id , xll.party_site_id --- NEED TO CHECK IF SAME CUSTOMER WITH DIFFERENT CUST SITE ID
1346: INTO l_third_party_id, l_third_party_site_id
1347: FROM gl_import_references glimp, GL_JE_LINES JL , xla_ae_lines xll
1348: WHERE glimp.je_header_id = p_je_header_id
1349: AND glimp.je_header_id = jl.je_header_id
1350: AND glimp.je_line_num = p_je_line_num
1351: AND glimp.je_line_num = jl.je_line_num
3246: ,'||g_last_update_login||'
3247: FROM (SELECT DISTINCT glcc.'||g_account_segment||' natural_acct
3248: FROM gl_je_headers jh
3249: ,gl_je_lines jl
3250: ,gl_import_references glimp
3251: ,xla_ae_lines xll
3252: ,xla_ae_headers xlh
3253: ,xla_distribution_links xld
3254: ,gl_code_combinations glcc
5227: , g_creation_date
5228: , g_last_updated_by
5229: , g_last_update_date
5230: , g_last_update_login
5231: FROM gl_import_references glimp,
5232: xla_ae_lines xll,
5233: xla_ae_headers xlh,
5234: XLA_DISTRIBUTION_LINKS xld
5235: WHERE glimp.je_header_id = p_journal_header_id
5299: , g_creation_date
5300: , g_last_updated_by
5301: , g_last_update_date
5302: , g_last_update_login
5303: FROM gl_import_references glimp,
5304: xla_ae_lines xll,
5305: xla_ae_headers xlh,
5306: XLA_DISTRIBUTION_LINKS xld
5307: WHERE glimp.je_header_id = p_journal_header_id
7610: INTO l_cnt
7611: FROM (SELECT jl.code_combination_id
7612: FROM gl_je_headers jh
7613: ,gl_je_lines jl
7614: ,gl_import_references glimp
7615: ,xla_ae_lines xll
7616: ,xla_ae_headers xlh
7617: ,xla_distribution_links xld
7618: WHERE jh.ledger_id = g_ledger_id
7658: INTO l_cnt
7659: FROM (SELECT jl.code_combination_id
7660: FROM gl_je_headers jh
7661: ,gl_je_lines jl
7662: ,gl_import_references glimp
7663: ,xla_ae_lines xll
7664: ,xla_ae_headers xlh
7665: ,xla_distribution_links xld
7666: WHERE jh.ledger_id = g_ledger_id