APPS.HRI_OPL_CMNTS_ACTLS_ORGMGR SQL Statements

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

Line: 151

  INSERT INTO HRI_MDP_CMNTS_ACTLS_ORGMGR_CT (
     orgmgr_id
    ,effective_start_date
    ,effective_end_date
    ,assignment_id
    ,organization_id
    ,job_id
    ,position_id
    ,grade_id
    ,element_type_id
    ,input_value_id
    ,cost_allocation_keyflex_id
    ,commitment_value
    ,dr_commitment_value
    ,actual_value
    ,dr_actual_value
    ,currency_code
    --
    -- WHO Columns
    --
    ,last_update_date
    ,last_update_login
    ,last_updated_by
    ,created_by
    ,creation_date)
   SELECT  orgmgr.sup_person_id                                                   ORGMGR_ID
          ,GREATEST(cmntactl.effective_start_date,orgmgr.effective_start_date)    EFFECTIVE_START_DATE
          ,LEAST(cmntactl.effective_end_date,orgmgr.effective_end_date)           EFFECTIVE_END_DATE
          ,cmntactl.assignment_id                                                 ASSIGNMENT_ID
          ,cmntactl.organization_id                                               ORGANIZATION_ID
          ,cmntactl.job_id                                                        JOB_ID
          ,cmntactl.position_id                                                   POSITION_ID
          ,cmntactl.grade_id                                                      GRADE_ID
          ,cmntactl.element_type_id                                               ELEMENT_TYPE_ID
          ,cmntactl.input_value_id                                                INPUT_VALUE_ID
          ,cmntactl.cost_allocation_keyflex_id                                    COST_ALLOCATION_KEYFLEX_ID
          ,CASE
            WHEN NVL(cmntactl.commitment_value,0) > NVL(cmntactl.actual_value,0)
             THEN (cmntactl.commitment_value - NVL(cmntactl.actual_value,0))
            ELSE 0
           END                                                                    COMMITMENT_VALUE
          ,CASE
            WHEN NVL(cmntactl.commitment_value,0) > NVL(cmntactl.actual_value,0)
             THEN (cmntactl.commitment_value - NVL(cmntactl.actual_value,0)) * DECODE(orgmgr.sub_relative_level, 0, 1, 0)
            ELSE 0
           END                                                                    DR_COMMITMENT_VALUE
          ,cmntactl.actual_value                                                  ACTUAL_VALUE
          ,cmntactl.actual_value * DECODE(orgmgr.sub_relative_level, 0, 1, 0)     DR_ACTUAL_VALUE
          ,cmntactl.currency_code                                                 CURRENCY_CODE
          ,SYSDATE
          ,l_user_id
          ,l_user_id
          ,l_user_id
          ,SYSDATE
    FROM  hri_md_cmnts_actls_ct cmntactl
         ,hri_cs_suph_orgmgr_ct orgmgr
   WHERE cmntactl.organization_id = orgmgr.sub_organization_id
     AND orgmgr.sup_person_id = p_person_id;

Line: 210

  dbg(SQL%ROWCOUNT||' records inserted into HRI_MDP_CMNTS_ACTLS_ORGMGR_CT');

Line: 259

      SELECT   DISTINCT sup_person_id
        FROM   hri_cs_suph_orgmgr_ct
       WHERE   sup_person_id BETWEEN p_start_object_id and p_end_object_id;

Line: 362

          'SELECT   /*+ parallel (ORGMGR, default, default) */
                    DISTINCT sup_person_id object_id
           FROM     hri_cs_suph_orgmgr_ct orgmgr
           ORDER BY sup_person_id';

Line: 474

      dbg('Full Refresh selected - Creating indexes');

Line: 485

        dbg('Full Refresh selected - gathering stats');

Line: 526

  SELECT mthd_range_id,
         min(object_id) start_object_id,
         max(object_id) end_object_id
  FROM   (SELECT  hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
                  ,object_id
          FROM    ( SELECT   DISTINCT sup_person_id object_id
                      FROM   hri_cs_suph_orgmgr_ct
                     ORDER BY sup_person_id)
          )
  GROUP BY mthd_range_id;