[Home] [Help]
162: v_rollback_flag VARCHAR2(1);
163:
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
271: THEN
272: BEGIN
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
789: INTO v_dummy
790: FROM DUAL
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'
5174: xla_third_parties_v p2,
5175: xla_third_party_sites_v s1,
5176: xla_third_party_sites_v s2,
5177: xla_transaction_entities ent,
5178: xla_ledger_options lgopt,
5179: xla_launch_options lnopt
5180: WHERE (p_event_id IS NULL OR evt.EVENT_ID = p_event_id)
5181: AND ( p_merge_event_set_id IS NULL
5182: OR evt.MERGE_EVENT_SET_ID = p_merge_event_set_id)
5215: OR (g_use_ledger_security = 'Y'
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'
5454: v_array_currency_code,
5455: v_array_mau,
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