APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_LEDGER_OPTIONS

Line 737: FROM xla_ledger_options xlo

733: FROM xla_ledger_relationships_v xlr
734: WHERE xlr.primary_ledger_id = g_ledger_id
735: AND xlr.relationship_enabled_flag = 'Y'
736: AND EXISTS (SELECT 1
737: FROM xla_ledger_options xlo
738: WHERE application_id = g_application_id
739: AND DECODE(xlr.ledger_category_code ,'ALC',xlr.ledger_id ,xlo.ledger_id) = xlr.ledger_id
740: AND DECODE(xlr.ledger_category_code ,'SECONDARY',xlo.capture_event_flag ,'N') = 'N'
741: AND DECODE(xlr.ledger_category_code ,'ALC','Y',xlo.enabled_flag) = 'Y' )

Line 990: xla_ledger_options xlo ,

986: ,DECODE(NVL(xal.analytical_balance_flag ,'N'),'N',NULL,'P')
987: , -9999
988: FROM xla_ae_lines xal ,
989: xla_ae_headers_gt xah ,
990: xla_ledger_options xlo ,
991: gl_ledgers gl
992: WHERE xal.application_id = g_application_id
993: AND xal.ae_header_id = xah.parent_header_id
994: AND xah.ledger_id = gl.ledger_id