DBA Data[Home] [Help]

APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_LEDGER_OPTIONS

Line 509: ,XLA_LEDGER_OPTIONS XLP

505: ,XLA_EVENT_TYPES_TL XTT
506: ,XLA_EVENT_CLASS_ATTRS XECA
507: ,XLA_LOOKUPS XLO1
508: ,XLA_LOOKUPS XLO2
509: ,XLA_LEDGER_OPTIONS XLP
510: WHERE xls.application_id = xle.application_id
511: AND xle.event_status_code IN (''I'',''U'')
512: AND xle.process_status_code IN (''U'',''D'',''E'',''R'',''I'')
513: AND xle.entity_id = ent.entity_id

Line 673: ,xla_ledger_options xlo

669: FROM xla_events xle
670: ,xla_event_types_b xcl
671: ,xla_event_class_attrs gjct
672: ,xla_transaction_entities ent
673: ,xla_ledger_options xlo
674: WHERE ent.entity_id = xle.entity_id
675: AND ent.application_id = xle.application_id
676: AND ent.ledger_id = xlo.ledger_id
677: AND ent.application_id = xlo.application_id

Line 1465: ,xla_ledger_options xlo

1461: FROM xla_events xle
1462: ,xla_transaction_entities xte
1463: ,gl_ledger_relationships glr1
1464: ,gl_ledger_relationships glr2
1465: ,xla_ledger_options xlo
1466: WHERE xle.entity_id = xte.entity_id
1467: AND xle.application_id = xte.application_id
1468: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date
1469: AND glr2.target_ledger_id = p_ledger_id

Line 1524: ,xla_ledger_options xlo

1520: FROM xla_events xle
1521: ,xla_transaction_entities xte
1522: ,gl_ledger_relationships glr1
1523: ,gl_ledger_relationships glr2
1524: ,xla_ledger_options xlo
1525: WHERE xle.entity_id = xte.entity_id
1526: AND xle.application_id = xte.application_id
1527: AND xle.event_date BETWEEN l_period_start_date and l_period_end_date
1528: AND xle.application_id = p_application_id