APPS.FEM_PL_INCR_PKG SQL Statements

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

Line: 146

      SELECT object_type_code
      INTO v_object_type
      FROM fem_object_catalog_b
      WHERE object_id = p_object_id;

Line: 310

         SELECT r.request_id
         FROM fem_pl_requests r,
              fem_pl_object_executions o
         WHERE r.cal_period_id       = p_cal_period_id
           AND r.ledger_id           = p_ledger_id
           AND r.output_dataset_code = p_dataset_code
           AND o.request_id          = r.request_id
           AND o.object_id           = p_object_id
           AND o.exec_status_code    = 'RUNNING';

Line: 368

         SELECT DISTINCT e.object_id, e.exec_object_definition_id
         INTO v_precedent_obj_id, v_precedent_obj_def_id
         FROM fem_pl_requests r,
              fem_pl_object_executions e,
              fem_object_catalog_b c1
         WHERE r.ledger_id           = p_ledger_id
           AND r.cal_period_id       = p_cal_period_id
           AND r.output_dataset_code = p_dataset_code
           AND e.request_id          = r.request_id
           AND c1.object_id          = e.object_id
           AND c1.object_type_code   =
              (SELECT object_type_code
               FROM fem_object_catalog_b c2
               WHERE c2.object_id = p_object_id);

Line: 477

      SELECT MAX(e.event_order)
      INTO v_prev_event_order
      FROM fem_pl_requests r,
           fem_pl_object_executions e
      WHERE r.ledger_id           = p_ledger_id
        AND r.cal_period_id       = p_cal_period_id
        AND r.output_dataset_code = p_dataset_code
        AND e.request_id          = r.request_id
        AND e.object_id           = p_object_id
        AND e.exec_object_definition_id = p_obj_def_id;

Line: 488

      SELECT exec_status_code, request_id
      INTO v_prev_exec_status_cd, v_prev_request_id
      FROM fem_pl_object_executions
      WHERE event_order = v_prev_event_order;

Line: 755

      SELECT COUNT(*)
      INTO v_row_count
      FROM fem_pl_requests r,
           fem_pl_object_executions o
      WHERE r.cal_period_id       = p_cal_period_id
        AND r.ledger_id           = p_ledger_id
        AND r.output_dataset_code = p_dataset_code
        AND r.exec_mode_code      = 'S'
        AND r.exec_status_code    = 'SUCCESS'
        AND o.request_id          = r.request_id
        AND o.object_id           = p_object_id;

Line: 885

      SELECT dimension_id
      INTO v_cal_per_dim_id
      FROM fem_dimensions_b
      WHERE dimension_varchar_label = 'CAL_PERIOD';

Line: 901

      SELECT date_assign_value
      INTO v_cal_per_end_date
      FROM fem_cal_periods_attr
      WHERE attribute_id  = v_dim_attr_id
        AND version_id    = v_dim_attr_ver_id
        AND cal_period_id = p_cal_period_id;

Line: 942

      SELECT count(*)
      INTO v_row_count
      FROM fem_pl_requests r,
           fem_pl_object_executions e,
           fem_object_catalog_b o,
           fem_cal_periods_attr a
      WHERE r.ledger_id           = p_ledger_id
        AND r.output_dataset_code = p_dataset_code
        AND r.exec_status_code    = 'SUCCESS'
        AND e.request_id          = r.request_id
        AND o.object_id           = e.object_id
        AND o.object_type_code    = 'XGL_INTEGRATION'
        AND a.attribute_id        = v_dim_attr_id
        AND a.version_id          = v_dim_attr_ver_id
        AND a.cal_period_id       = r.cal_period_id
        AND a.date_assign_value   > v_cal_per_end_date;

Line: 1100

         SELECT r.request_id
         FROM fem_pl_requests r,
              fem_pl_object_executions o
         WHERE r.cal_period_id       = p_cal_period_id
           AND r.ledger_id           = p_ledger_id
           AND r.output_dataset_code = p_dataset_code
           AND r.source_system_code  = p_source_system_code
           AND r.table_name          = p_table_name
           AND o.request_id          = r.request_id
           AND o.object_id           = p_object_id
           AND o.exec_status_code    = G_RUNNING;

Line: 1161

      SELECT MAX(e.event_order)
      INTO v_prev_event_order
      FROM fem_pl_requests r,
           fem_pl_object_executions e
      WHERE r.ledger_id           = p_ledger_id
        AND r.cal_period_id       = p_cal_period_id
        AND r.output_dataset_code = p_dataset_code
        AND r.source_system_code  = p_source_system_code
        AND r.table_name          = p_table_name
        AND e.request_id          = r.request_id
        AND e.object_id           = p_object_id
        AND e.exec_object_definition_id = p_obj_def_id;

Line: 1175

      SELECT exec_status_code, request_id
      INTO v_prev_exec_status_cd, v_prev_request_id
      FROM fem_pl_object_executions
      WHERE event_order = v_prev_event_order;

Line: 1423

         SELECT COUNT(*)
         INTO v_row_count
         FROM fem_pl_requests r,
              fem_pl_object_executions o,
              fem_pl_tables t
         WHERE r.cal_period_id       = p_cal_period_id
           AND r.ledger_id           = p_ledger_id
           AND r.output_dataset_code = p_dataset_code
           AND r.source_system_code  = p_source_system_code
           AND r.table_name          = p_table_name
           AND t.request_id          = o.request_id
           AND t.object_id           = o.object_id
           AND t.num_of_output_rows  > 0
           AND o.request_id          = r.request_id
           AND o.object_id           = p_object_id;

Line: 1475

         SELECT COUNT(*)
         INTO v_row_count
         FROM fem_pl_requests r,
              fem_pl_object_executions o
         WHERE r.cal_period_id       = p_cal_period_id
           AND r.ledger_id           = p_ledger_id
           AND r.output_dataset_code = p_dataset_code
           AND r.source_system_code  = p_source_system_code
           AND r.table_name          = p_table_name
           AND r.exec_mode_code      = G_SNAPSHOT
           AND o.request_id          = r.request_id
           AND o.object_id           = p_object_id;