DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PUB_PKG dependencies on XLA_EVENT_CLASS_PREDECS

Line 607: FROM xla_event_class_predecs

603: , NVL(t.max_level, -1)
604: FROM xla_event_classes_b xec
605: , (SELECT application_id, event_class_code, max(LEVEL) AS max_level
606: FROM (SELECT application_id, event_class_code, prior_event_class_code
607: FROM xla_event_class_predecs
608: WHERE application_id = p_application_id
609: UNION
610: SELECT application_id, prior_event_class_code, NULL
611: FROM xla_event_class_predecs

Line 611: FROM xla_event_class_predecs

607: FROM xla_event_class_predecs
608: WHERE application_id = p_application_id
609: UNION
610: SELECT application_id, prior_event_class_code, NULL
611: FROM xla_event_class_predecs
612: WHERE application_id = p_application_id) xep
613: CONNECT BY application_id = PRIOR application_id
614: AND prior_event_class_code = PRIOR event_class_code
615: GROUP BY application_id, event_class_code) t

Line 721: FROM xla_event_class_predecs

717: , NVL(t.max_level, -1)
718: FROM xla_event_classes_b xec
719: , (SELECT application_id, event_class_code, max(LEVEL) AS max_level
720: FROM (SELECT application_id, event_class_code, prior_event_class_code
721: FROM xla_event_class_predecs
722: WHERE application_id = p_application_id
723: UNION
724: SELECT application_id, prior_event_class_code, NULL
725: FROM xla_event_class_predecs

Line 725: FROM xla_event_class_predecs

721: FROM xla_event_class_predecs
722: WHERE application_id = p_application_id
723: UNION
724: SELECT application_id, prior_event_class_code, NULL
725: FROM xla_event_class_predecs
726: WHERE application_id = p_application_id) xep
727: CONNECT BY application_id = PRIOR application_id
728: AND prior_event_class_code = PRIOR event_class_code
729: GROUP BY application_id, event_class_code) t