DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_EVENT_CLASS_PREDECS

Line 3542: FROM xla_event_class_predecs

3538: , NVL(t.max_level, -1)
3539: FROM xla_event_classes_b xec
3540: , (SELECT application_id, event_class_code, max(LEVEL) AS max_level
3541: FROM (SELECT application_id, event_class_code, prior_event_class_code
3542: FROM xla_event_class_predecs
3543: WHERE application_id = p_application_id
3544: UNION
3545: SELECT application_id, prior_event_class_code, NULL
3546: FROM xla_event_class_predecs

Line 3546: FROM xla_event_class_predecs

3542: FROM xla_event_class_predecs
3543: WHERE application_id = p_application_id
3544: UNION
3545: SELECT application_id, prior_event_class_code, NULL
3546: FROM xla_event_class_predecs
3547: WHERE application_id = p_application_id) xep
3548: CONNECT BY application_id = PRIOR application_id
3549: AND prior_event_class_code = PRIOR event_class_code
3550: GROUP BY application_id, event_class_code) t

Line 5078: FROM xla_event_class_predecs

5074: , NVL(t.max_level, -1)
5075: FROM xla_event_classes_b xec
5076: , (SELECT application_id, event_class_code, max(LEVEL) AS max_level
5077: FROM (SELECT application_id, event_class_code, prior_event_class_code
5078: FROM xla_event_class_predecs
5079: WHERE application_id = g_application_id
5080: UNION
5081: SELECT application_id, prior_event_class_code, NULL
5082: FROM xla_event_class_predecs

Line 5082: FROM xla_event_class_predecs

5078: FROM xla_event_class_predecs
5079: WHERE application_id = g_application_id
5080: UNION
5081: SELECT application_id, prior_event_class_code, NULL
5082: FROM xla_event_class_predecs
5083: WHERE application_id = g_application_id) xep
5084: CONNECT BY application_id = PRIOR application_id
5085: AND prior_event_class_code = PRIOR event_class_code
5086: GROUP BY application_id, event_class_code) t