[Home] [Help]
166: CURSOR ledger_cur IS
167: SELECT DISTINCT opt.LEDGER_ID
168: FROM XLA_LEDGER_OPTIONS opt,
169: XLA_LEDGER_RELATIONSHIPS_V rs,
170: gl_ledgers gl
171: WHERE (p_ledger_id IS NULL OR opt.LEDGER_ID = p_ledger_id)
172: AND opt.APPLICATION_ID = p_application_id
173: AND opt.ENABLED_FLAG = 'Y'
174: AND rs.LEDGER_ID = opt.LEDGER_ID
275: SELECT 'X'
276: INTO v_dummy
277: FROM XLA_LEDGER_OPTIONS opt,
278: XLA_LEDGER_RELATIONSHIPS_V rs,
279: gl_ledgers gl
280: WHERE opt.LEDGER_ID = p_ledger_id
281: AND opt.APPLICATION_ID = p_application_id
282: AND opt.ENABLED_FLAG = 'Y'
283: AND rs.LEDGER_ID = opt.LEDGER_ID
582: WHERE EXISTS
583: (SELECT 'X'
584: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
585: XLA_MERGE_SEG_MAPS_GT gt,
586: gl_ledgers gld
587: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
588: AND rs.ledger_id = gld.ledger_id
589: AND gld.complete_flag = 'Y'
590: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
692: sysdate,
693: XLA_ENVIRONMENT_PKG.g_prog_appl_id
694: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
695: XLA_MERGE_SEG_MAPS_GT gt,
696: GL_LEDGERS gl
697: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
698: AND rs.ledger_id = gl.ledger_id
699: AND gl.complete_flag = 'Y'
700: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
798: WHERE EXISTS
799: (SELECT 'Ledger without access'
800: FROM XLA_LEDGER_OPTIONS opt,
801: XLA_LEDGER_RELATIONSHIPS_V rs,
802: GL_LEDGERS gld
803: WHERE opt.APPLICATION_ID = p_application_id
804: AND opt.ENABLED_FLAG = 'Y'
805: AND opt.MERGE_ACCT_OPTION_CODE <> 'NONE'
806: AND DECODE(rs.LEDGER_CATEGORY_CODE
4478: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4479: from xla_merge_seg_maps map
4480: ,gl_code_combinations gcc
4481: ,XLA_LEDGER_RELATIONSHIPS_V rs
4482: ,gl_ledgers gld
4483: where map.application_id = p_application_id
4484: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4485: AND rs.ledger_id = gld.ledger_id
4486: AND gld.complete_flag = 'Y'
4528: (select 1
4529: from xla_merge_seg_maps map
4530: ,gl_code_combinations gcc
4531: ,XLA_LEDGER_RELATIONSHIPS_V rs
4532: ,gl_ledgers gld
4533: where map.application_id = p_application_id
4534: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4535: AND rs.ledger_id = gld.ledger_id
4536: AND gld.complete_flag = 'Y'
4711: ,xla_ae_lines ael
4712: ,xla_ae_headers aeh
4713: ,XLA_PARTIAL_MERGE_TXNS xpmt
4714: ,XLA_LEDGER_RELATIONSHIPS_V rs
4715: ,gl_ledgers gld
4716: WHERE ael.PARTY_ID = p_old_party_id
4717: AND (p_old_site_id IS NULL
4718: OR ael.PARTY_SITE_ID = p_old_site_id)
4719: AND ael.PARTY_TYPE_CODE = p_party_type
4860: ,gl_code_combinations gcc
4861: ,xla_ae_lines ael
4862: ,xla_ae_headers aeh
4863: ,XLA_LEDGER_RELATIONSHIPS_V rs
4864: ,gl_ledgers gld
4865: WHERE ael.PARTY_ID = p_old_party_id
4866: AND (p_old_site_id IS NULL
4867: OR ael.PARTY_SITE_ID = p_old_site_id)
4868: AND ael.PARTY_TYPE_CODE = p_party_type
5268: AND NOT EXISTS
5269: (SELECT 'Ledger without access'
5270: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5271: XLA_LEDGER_OPTIONS lgopt2,
5272: gl_ledgers gld
5273: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
5274: AND rs.ledger_id = gld.ledger_id
5275: AND gld.complete_flag = 'Y'
5276: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
5512: AND NOT EXISTS
5513: (SELECT ''Ledger without access''
5514: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5515: XLA_LEDGER_OPTIONS lgopt2,
5516: gl_ledgers gld
5517: WHERE rs.RELATIONSHIP_ENABLED_FLAG = ''Y''
5518: AND rs.ledger_id = gld.ledger_id
5519: AND gld.complete_flag = ''Y''
5520: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
5621: v_array_submit_transfer
5622: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5623: XLA_LEDGER_OPTIONS lgopt,
5624: FND_CURRENCIES fcu,
5625: GL_LEDGERS gld
5626: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
5627: AND rs.ledger_id = gld.ledger_id
5628: AND gld.complete_flag = 'Y'
5629: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL