APPS.XLA_ACCOUNTING_CACHE_PKG dependencies on XLA_SUBLEDGER_OPTIONS_V

Line 418: FROM xla_subledger_options_v xso

414: ,xso.transaction_calendar_id transaction_calendar_id
415: ,xso.enable_average_balances_flag enable_average_balances_flag
416: ,gjs.effective_date_rule_code effective_date_rule_code
417: ,xso.suspense_allowed_flag suspense_allowed_flag
418: FROM xla_subledger_options_v xso
419: ,fnd_application_tl fat
420: ,gl_je_sources_vl gjs
421: ,fnd_id_flex_structures_tl fst
422: ,fnd_id_flex_structures_vl fsv

Line 650: FROM xla_subledger_options_v xso

646: ,xso.transaction_calendar_id transaction_calendar_id
647: ,xso.enable_average_balances_flag enable_average_balances_flag
648: ,gjs.effective_date_rule_code effective_date_rule_code
649: ,xso.suspense_allowed_flag suspense_allowed_flag
650: FROM xla_subledger_options_v xso
651: ,fnd_application_tl fat
652: ,gl_je_sources_vl gjs
653: ,fnd_id_flex_structures_tl fst
654: ,fnd_id_flex_structures_vl fsv

Line 706: FROM xla_subledger_options_v xso

702:
703: --Bug :11680489- Code change for VM based secondary ledger having different CoA than primary
704: CURSOR csr IS
705: SELECT xso.primary_ledger_id
706: FROM xla_subledger_options_v xso
707: WHERE xso.ledger_id = p_event_ledger_id
708: AND xso.application_id =p_application_id
709: AND ledger_category_code = 'SECONDARY'
710: AND valuation_method_flag = 'Y';

Line 2766: FROM xla_subledger_options_v xso

2762: SELECT ect.event_class_code event_class_code
2763: ,ect.name ledger_event_class_name
2764: ,ecv.name session_event_class_name
2765: ,ect.language language
2766: FROM xla_subledger_options_v xso
2767: ,xla_event_classes_tl ect
2768: ,xla_event_classes_vl ecv
2769: WHERE xso.application_id = p_application_id
2770: AND DECODE(xso.valuation_method_flag

Line 2789: FROM xla_subledger_options_v xso

2785: CURSOR csr_je_category(x_event_ledger_category IN VARCHAR2) IS
2786: SELECT xjc.event_class_code event_class_code
2787: ,xjc.je_category_name je_category_name
2788: ,xso.ledger_id ledger_id
2789: FROM xla_subledger_options_v xso
2790: ,xla_je_categories xjc
2791: WHERE xso.application_id = p_application_id
2792: AND xso.enabled_flag = 'Y'
2793: AND xjc.application_id = p_application_id

Line 2810: FROM xla_subledger_options_v xso

2806: SELECT ett.event_type_code event_type_code
2807: ,ett.name ledger_event_type_name
2808: ,etv.name session_event_type_name
2809: ,ett.language language
2810: FROM xla_subledger_options_v xso
2811: ,xla_event_types_tl ett
2812: ,xla_event_types_vl etv
2813: WHERE xso.application_id = p_application_id
2814: AND DECODE(xso.valuation_method_flag