APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_LEDGER_OPTIONS

Line 168: FROM XLA_LEDGER_OPTIONS opt,

164: v_rollback_flag VARCHAR2(1);
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

Line 277: FROM XLA_LEDGER_OPTIONS opt,

273: THEN
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

Line 800: FROM XLA_LEDGER_OPTIONS opt,

796: INTO v_dummy
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'

Line 5225: xla_ledger_options lgopt,

5221: xla_third_parties_v p2,
5222: xla_third_party_sites_v s1,
5223: xla_third_party_sites_v s2,
5224: xla_transaction_entities ent,
5225: xla_ledger_options lgopt,
5226: xla_launch_options lnopt
5227: WHERE
5228: */ -- 14773226
5229: /*(p_event_id IS NULL OR evt.EVENT_ID = p_event_id)

Line 5271: XLA_LEDGER_OPTIONS lgopt2,

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
5275: AND gld.complete_flag = 'Y'

Line 5469: xla_ledger_options lgopt,

5465: xla_third_parties_v p2,
5466: xla_third_party_sites_v s1,
5467: xla_third_party_sites_v s2,
5468: xla_transaction_entities ent,
5469: xla_ledger_options lgopt,
5470: xla_launch_options lnopt
5471: WHERE ';
5472: IF P_EVENT_ID IS NOT NULL THEN
5473: v_mergeEvent_sql := v_mergeEvent_sql || ' EVT.EVENT_ID = ' || P_EVENT_ID || ' AND ';

Line 5515: XLA_LEDGER_OPTIONS lgopt2,

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
5519: AND gld.complete_flag = ''Y''

Line 5623: XLA_LEDGER_OPTIONS lgopt,

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'
5627: AND rs.ledger_id = gld.ledger_id