[Home] [Help]
165:
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'
274: BEGIN
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'
580: INTO v_mapping_flag
581: FROM DUAL
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
690: XLA_ENVIRONMENT_PKG.g_usr_id,
691: XLA_ENVIRONMENT_PKG.g_login_id,
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
797: FROM DUAL
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'
4477: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
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
4527: AND exists
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
4710: ,gl_code_combinations gcc
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)
4859: FROM xla_merge_seg_maps map
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)
5266: AND ( g_use_ledger_security = 'N'
5267: OR (g_use_ledger_security = 'Y'
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
5510: AND ( ''' || g_use_ledger_security || ''' = ''N''
5511: OR (''' || g_use_ledger_security || ''' =''Y''
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
5618: v_array_rounding_rule_code,
5619: v_array_currency_code,
5620: v_array_mau,
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'