APPS.XLA_THIRD_PARTY_MERGE dependencies on GL_LEDGERS

Line 168: gl_ledgers gl

164: CURSOR ledger_cur IS
165: SELECT DISTINCT opt.LEDGER_ID
166: FROM XLA_LEDGER_OPTIONS opt,
167: XLA_LEDGER_RELATIONSHIPS_V rs,
168: gl_ledgers gl
169: WHERE (p_ledger_id IS NULL OR opt.LEDGER_ID = p_ledger_id)
170: AND opt.APPLICATION_ID = p_application_id
171: AND opt.ENABLED_FLAG = 'Y'
172: AND rs.LEDGER_ID = opt.LEDGER_ID

Line 277: gl_ledgers gl

273: SELECT 'X'
274: INTO v_dummy
275: FROM XLA_LEDGER_OPTIONS opt,
276: XLA_LEDGER_RELATIONSHIPS_V rs,
277: gl_ledgers gl
278: WHERE opt.LEDGER_ID = p_ledger_id
279: AND opt.APPLICATION_ID = p_application_id
280: AND opt.ENABLED_FLAG = 'Y'
281: AND rs.LEDGER_ID = opt.LEDGER_ID

Line 581: gl_ledgers gld

577: WHERE EXISTS
578: (SELECT 'X'
579: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
580: XLA_MERGE_SEG_MAPS_GT gt,
581: gl_ledgers gld
582: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
583: AND rs.ledger_id = gld.ledger_id
584: AND gld.complete_flag = 'Y'
585: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL

Line 689: GL_LEDGERS gl

685: sysdate,
686: XLA_ENVIRONMENT_PKG.g_prog_appl_id
687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
688: XLA_MERGE_SEG_MAPS_GT gt,
689: GL_LEDGERS gl
690: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
691: AND rs.ledger_id = gl.ledger_id
692: AND gl.complete_flag = 'Y'
693: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL

Line 795: GL_LEDGERS gld

791: WHERE EXISTS
792: (SELECT 'Ledger without access'
793: FROM XLA_LEDGER_OPTIONS opt,
794: XLA_LEDGER_RELATIONSHIPS_V rs,
795: GL_LEDGERS gld
796: WHERE opt.APPLICATION_ID = p_application_id
797: AND opt.ENABLED_FLAG = 'Y'
798: AND opt.MERGE_ACCT_OPTION_CODE <> 'NONE'
799: AND DECODE(rs.LEDGER_CATEGORY_CODE

Line 4437: ,gl_ledgers gld

4433: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4434: from xla_merge_seg_maps map
4435: ,gl_code_combinations gcc
4436: ,XLA_LEDGER_RELATIONSHIPS_V rs
4437: ,gl_ledgers gld
4438: where map.application_id = p_application_id
4439: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4440: AND rs.ledger_id = gld.ledger_id
4441: AND gld.complete_flag = 'Y'

Line 4487: ,gl_ledgers gld

4483: (select 1
4484: from xla_merge_seg_maps map
4485: ,gl_code_combinations gcc
4486: ,XLA_LEDGER_RELATIONSHIPS_V rs
4487: ,gl_ledgers gld
4488: where map.application_id = p_application_id
4489: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4490: AND rs.ledger_id = gld.ledger_id
4491: AND gld.complete_flag = 'Y'

Line 4670: ,gl_ledgers gld

4666: ,xla_ae_lines ael
4667: ,xla_ae_headers aeh
4668: ,XLA_PARTIAL_MERGE_TXNS xpmt
4669: ,XLA_LEDGER_RELATIONSHIPS_V rs
4670: ,gl_ledgers gld
4671: WHERE ael.PARTY_ID = p_old_party_id
4672: AND (p_old_site_id IS NULL
4673: OR ael.PARTY_SITE_ID = p_old_site_id)
4674: AND ael.PARTY_TYPE_CODE = p_party_type

Line 4819: ,gl_ledgers gld

4815: ,gl_code_combinations gcc
4816: ,xla_ae_lines ael
4817: ,xla_ae_headers aeh
4818: ,XLA_LEDGER_RELATIONSHIPS_V rs
4819: ,gl_ledgers gld
4820: WHERE ael.PARTY_ID = p_old_party_id
4821: AND (p_old_site_id IS NULL
4822: OR ael.PARTY_SITE_ID = p_old_site_id)
4823: AND ael.PARTY_TYPE_CODE = p_party_type

Line 5220: gl_ledgers gld

5216: AND NOT EXISTS
5217: (SELECT 'Ledger without access'
5218: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5219: XLA_LEDGER_OPTIONS lgopt2,
5220: gl_ledgers gld
5221: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
5222: AND rs.ledger_id = gld.ledger_id
5223: AND gld.complete_flag = 'Y'
5224: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL

Line 5460: GL_LEDGERS gld

5456: v_array_submit_transfer
5457: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5458: XLA_LEDGER_OPTIONS lgopt,
5459: FND_CURRENCIES fcu,
5460: GL_LEDGERS gld
5461: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
5462: AND rs.ledger_id = gld.ledger_id
5463: AND gld.complete_flag = 'Y'
5464: AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL