DBA Data[Home] [Help]

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_LEDGER_OPTIONS

Line 503: ,XLA_LEDGER_OPTIONS XLP

499: ,XLA_EVENT_TYPES_TL XTT
500: ,XLA_EVENT_CLASS_ATTRS XECA
501: ,XLA_LOOKUPS XLO1
502: ,XLA_LOOKUPS XLO2
503: ,XLA_LEDGER_OPTIONS XLP
504: WHERE xls.application_id = xle.application_id
505: AND xle.event_status_code IN (''I'',''U'')
506: AND xle.process_status_code IN (''U'',''D'',''E'',''R'',''I'')
507: AND xle.entity_id = ent.entity_id

Line 666: ,xla_ledger_options xlo

662: FROM xla_events xle
663: ,xla_event_types_b xcl
664: ,xla_event_class_attrs gjct
665: ,xla_transaction_entities ent
666: ,xla_ledger_options xlo
667: WHERE ent.entity_id = xle.entity_id
668: AND ent.application_id = xle.application_id
669: AND ent.ledger_id = xlo.ledger_id
670: AND ent.application_id = xlo.application_id

Line 1414: ,xla_ledger_options xlo

1410: FROM xla_events xle
1411: ,xla_transaction_entities xte
1412: ,gl_ledger_relationships glr1
1413: ,gl_ledger_relationships glr2
1414: ,xla_ledger_options xlo
1415: WHERE xle.entity_id = xte.entity_id
1416: AND xle.application_id = xte.application_id
1417: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date
1418: AND glr2.target_ledger_id = p_ledger_id

Line 1473: ,xla_ledger_options xlo

1469: FROM xla_events xle
1470: ,xla_transaction_entities xte
1471: ,gl_ledger_relationships glr1
1472: ,gl_ledger_relationships glr2
1473: ,xla_ledger_options xlo
1474: WHERE xle.entity_id = xte.entity_id
1475: AND xle.application_id = xte.application_id
1476: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date
1477: AND xle.application_id = p_application_id