[Home] [Help]
567: and xah.ledger_id = g_ledger_id_tab(i)
568: and xah.funds_status_code is null
569: and xah.balance_type_code in ('A', 'E')
570: and exists
571: (select 1 from xla_events xe
572: where xe.entity_id = xah.entity_id
573: and xe.application_id = xah.application_id
574: and xe.budgetary_control_flag = 'Y')
575: ;
1173: ,p_value_1 => 'The ledger setup is not complete. Please run Update Subledger Accounting Options program for your application '||
1174: 'ledger_id = '||p_ledger_id||
1175: ' application_id = '|| g_application_id
1176: ,p_token_2 => 'LOCATION'
1177: ,p_value_2 => 'xla_events_pkg.get_ledger_options');
1178: END;
1179:
1180: -- Derive access set id based on the use ledger security option
1181: --
1205: ,p_token_1 => 'ERROR'
1206: ,p_value_1 => 'Access set Id not found for the ledger ID = '
1207: ||p_ledger_id
1208: ,p_token_2 => 'LOCATION'
1209: ,p_value_2 => 'xla_events_pkg.get_ledger_options');
1210: trace('Access set Id not found.',C_LEVEL_STATEMENT,l_Log_module);
1211:
1212: END;
1213: END IF;
2214: )
2215: AND EXISTS
2216: (
2217: -- added hint for perf bug#10047096
2218: SELECT /*+ no_unnest */ 1 FROM xla_events xle
2219: WHERE xah.event_id = xle.event_id
2220: AND xah.application_id = xle.application_id
2221: AND xle.event_status_code = 'P'
2222: AND xle.process_status_code = 'P'
2250: AND aeh.application_id = xal.application_id
2251: )
2252: AND EXISTS
2253: (
2254: SELECT 1 FROM xla_events xle
2255: WHERE aeh.event_id = xle.event_id
2256: AND aeh.application_id = xle.application_id
2257: AND xle.event_status_code = 'P'
2258: AND xle.process_status_code = 'P'
2285: AND aeh.application_id = xal.application_id
2286: )
2287: AND EXISTS
2288: (
2289: SELECT 1 FROM xla_events xle
2290: WHERE aeh.event_id = xle.event_id
2291: AND aeh.application_id = xle.application_id
2292: AND xle.event_status_code = 'P'
2293: AND xle.process_status_code = 'P'
2320: AND aeh.application_id = xal.application_id
2321: )
2322: AND EXISTS
2323: (
2324: SELECT 1 FROM xla_events xle
2325: WHERE aeh.event_id = xle.event_id
2326: AND aeh.application_id = xle.application_id
2327: AND xle.event_status_code = 'P'
2328: AND xle.process_status_code = 'P'
2399: AND aeh.application_id = xal.application_id
2400: )
2401: AND EXISTS
2402: (
2403: SELECT 1 FROM xla_events xle
2404: WHERE aeh.event_id = xle.event_id
2405: AND aeh.application_id = xle.application_id
2406: AND xle.event_status_code = ''P''
2407: AND xle.process_status_code = ''P''