eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AMB_AAD_PKG dependencies on XLA_EVT_CLASS_ACCT_ATTRS

Line 113: FROM xla_evt_class_acct_attrs e

109: -- Check if the accounting reversal option is set for the event class
110: CURSOR c_event_sources
111: IS
112: SELECT 'x'
113: FROM xla_evt_class_acct_attrs e
114: WHERE e.application_id = p_application_id
115: AND e.event_class_code = p_event_class_code
116: AND e.accounting_attribute_code IN ('ACCOUNTING_REVERSAL_OPTION','TRX_ACCT_REVERSAL_OPTION');
117:

Line 200: FROM xla_evt_class_acct_attrs e

196: SELECT a.accounting_attribute_code
197: FROM xla_acct_attributes_b a
198: WHERE a.assignment_required_code = 'Y'
199: AND NOT EXISTS (SELECT 'x'
200: FROM xla_evt_class_acct_attrs e
201: WHERE e.application_id = p_application_id
202: AND e.event_class_code = p_event_class_code
203: AND e.accounting_attribute_code = a.accounting_attribute_code
204: AND e.default_flag = 'Y');

Line 216: FROM xla_evt_class_acct_attrs e

212: SELECT distinct a.assignment_group_code
213: FROM xla_acct_attributes_b a
214: WHERE assignment_group_code is NOT NULL
215: AND EXISTS (SELECT 'x'
216: FROM xla_evt_class_acct_attrs e
217: WHERE e.application_id = p_application_id
218: AND e.event_class_code = p_event_class_code
219: AND e.accounting_attribute_code = a.accounting_attribute_code
220: AND e.default_flag = 'Y');

Line 233: FROM xla_evt_class_acct_attrs e

229: FROM xla_acct_attributes_b s
230: WHERE assignment_required_code = 'G'
231: AND assignment_group_code = p_assignment_group_code
232: AND not exists (SELECT 'x'
233: FROM xla_evt_class_acct_attrs e
234: WHERE e.application_id = p_application_id
235: AND e.event_class_code = p_event_class_code
236: AND e.accounting_attribute_code = s.accounting_attribute_code
237: AND e.default_flag = 'Y');

Line 256: FROM xla_evt_class_acct_attrs e

252: -- Check if event class has budget version id accounting attribute mapped
253: CURSOR c_budget
254: IS
255: SELECT 'x'
256: FROM xla_evt_class_acct_attrs e
257: WHERE e.application_id = p_application_id
258: AND e.event_class_code = p_event_class_code
259: AND e.accounting_attribute_code = 'BUDGET_VERSION_ID'
260: AND e.default_flag = 'Y';

Line 267: FROM xla_evt_class_acct_attrs e

263: /*4458381
264: CURSOR c_enc
265: IS
266: SELECT 'x'
267: FROM xla_evt_class_acct_attrs e
268: WHERE e.application_id = p_application_id
269: AND e.event_class_code = p_event_class_code
270: AND e.accounting_attribute_code = 'ENCUMBRANCE_TYPE_ID'
271: AND e.default_flag = 'Y';

Line 278: FROM xla_evt_class_acct_attrs_fvl a

274: -- Check if reversed distribution id 2 is mapped for the event class
275: CURSOR c_rev_dist_2
276: IS
277: SELECT a.accounting_attribute_code, a.assignment_group_code
278: FROM xla_evt_class_acct_attrs_fvl a
279: WHERE a.application_id = p_application_id
280: AND a.event_class_code = p_event_class_code
281: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID2'
282: AND default_flag = 'Y';

Line 290: FROM xla_evt_class_acct_attrs a

286: -- Check if distribution id 2 is mapped for the event class
287: CURSOR c_dist_2
288: IS
289: SELECT 'x'
290: FROM xla_evt_class_acct_attrs a
291: WHERE a.application_id = p_application_id
292: AND a.event_class_code = p_event_class_code
293: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_2'
294: AND default_flag = 'Y';

Line 300: FROM xla_evt_class_acct_attrs_fvl a

296: -- Check if reversed distribution id 3 is mapped for the event class
297: CURSOR c_rev_dist_3
298: IS
299: SELECT a.accounting_attribute_code, a.assignment_group_code
300: FROM xla_evt_class_acct_attrs_fvl a
301: WHERE a.application_id = p_application_id
302: AND a.event_class_code = p_event_class_code
303: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID3'
304: AND default_flag = 'Y';

Line 312: FROM xla_evt_class_acct_attrs a

308: -- Check if distribution id 3 is mapped for the event class
309: CURSOR c_dist_3
310: IS
311: SELECT 'x'
312: FROM xla_evt_class_acct_attrs a
313: WHERE a.application_id = p_application_id
314: AND a.event_class_code = p_event_class_code
315: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_3'
316: AND a.default_flag = 'Y';

Line 322: FROM xla_evt_class_acct_attrs_fvl a

318: -- Check if reversed distribution id 4 is mapped for the event class
319: CURSOR c_rev_dist_4
320: IS
321: SELECT a.accounting_attribute_code, a.assignment_group_code
322: FROM xla_evt_class_acct_attrs_fvl a
323: WHERE a.application_id = p_application_id
324: AND a.event_class_code = p_event_class_code
325: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID4'
326: AND default_flag = 'Y';

Line 334: FROM xla_evt_class_acct_attrs a

330: -- Check if distribution id 4 is mapped for the event class
331: CURSOR c_dist_4
332: IS
333: SELECT 'x'
334: FROM xla_evt_class_acct_attrs a
335: WHERE a.application_id = p_application_id
336: AND a.event_class_code = p_event_class_code
337: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_4'
338: AND default_flag = 'Y';

Line 344: FROM xla_evt_class_acct_attrs_fvl a

340: -- Check if reversed distribution id 5 is mapped for the event class
341: CURSOR c_rev_dist_5
342: IS
343: SELECT a.accounting_attribute_code, a.assignment_group_code
344: FROM xla_evt_class_acct_attrs_fvl a
345: WHERE a.application_id = p_application_id
346: AND a.event_class_code = p_event_class_code
347: AND a.accounting_attribute_code = 'REVERSED_DISTRIBUTION_ID5'
348: AND a.default_flag = 'Y';

Line 356: FROM xla_evt_class_acct_attrs a

352: -- Check if distribution id 5 is mapped for the event class
353: CURSOR c_dist_5
354: IS
355: SELECT 'x'
356: FROM xla_evt_class_acct_attrs a
357: WHERE a.application_id = p_application_id
358: AND a.event_class_code = p_event_class_code
359: AND a.accounting_attribute_code = 'DISTRIBUTION_IDENTIFIER_5'
360: AND a.default_flag = 'Y';

Line 369: FROM xla_evt_class_acct_attrs s

365: CURSOR c_sources
366: IS
367: SELECT s.accounting_attribute_code, s.source_application_id,
368: s.source_type_code, s.source_code
369: FROM xla_evt_class_acct_attrs s
370: WHERE s.application_id = p_application_id
371: AND s.event_class_code = p_event_class_code
372: AND s.source_application_id = p_application_id
373: AND s.source_type_code = 'S'

Line 392: FROM xla_evt_class_acct_attrs s

388: CURSOR c_der_sources
389: IS
390: SELECT s.accounting_attribute_code, s.source_application_id,
391: s.source_type_code, s.source_code
392: FROM xla_evt_class_acct_attrs s
393: WHERE s.application_id = p_application_id
394: AND s.event_class_code = p_event_class_code
395: AND s.source_application_id = p_application_id
396: AND s.source_type_code = 'D';