APPS.XLA_EVENT_TYPES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 59

   SELECT 'x'
     FROM xla_prod_acct_headers
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code
      AND event_type_code  = p_event_type_code;

Line: 68

   SELECT 'x'
     FROM xla_line_definitions_b
    WHERE application_id   = p_application_id
      AND event_class_code = p_event_class_code
      AND event_type_code  = p_event_type_code;

Line: 76

   SELECT count(1)
     FROM xla_event_types_vl
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code
      AND event_type_code <> p_event_class_code||'_ALL'
      AND accounting_flag  = 'Y'
      AND enabled_flag     = 'Y';

Line: 87

   SELECT 'x'
     FROM xla_prod_acct_headers
    WHERE application_id   = p_application_id
      AND entity_code      = p_entity_code
      AND event_class_code = p_event_class_code
      AND event_type_code  = p_event_class_code||'_ALL';

Line: 96

   SELECT 'x'
     FROM xla_line_definitions_b
    WHERE application_id   = p_application_id
      AND event_class_code = p_event_class_code
      AND event_type_code  = p_event_class_code||'_ALL';

Line: 111

   IF p_event in ('DELETE','DISABLE') THEN

      IF p_accounting_flag = 'Y' THEN

         OPEN check_prod_rules;