APPS.HRI_OPL_BDGTS_HDCNT_ORGMGR SQL Statements

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

Line: 112

  INSERT INTO HRI_MDP_BDGTS_HDCNT_ORGMGR_CT (
     orgmgr_id
    ,budget_id
    ,budget_aggregate
    ,effective_start_date
    ,effective_end_date
    ,organization_id
    ,job_id
    ,position_id
    ,grade_id
    ,headcount_value
    ,dr_headcount_value
    --
    -- WHO Columns
    --
    ,last_update_date
    ,last_update_login
    ,last_updated_by
    ,created_by
    ,creation_date)
   SELECT  orgmgr.sup_person_id                                       ORGMGR_ID
          ,budget_id                                                  BUDGET_ID
          ,budget_aggregate                                           BUDGET_AGGREGATE
          ,GREATEST(period_start_date,orgmgr.effective_start_date)    EFFECTIVE_START_DATE
          ,LEAST(period_end_date,orgmgr.effective_end_date)           EFFECTIVE_END_DATE
          ,organization_id                                            ORGANIZATION_ID
          ,job_id                                                     JOB_ID
          ,position_id                                                POSITION_ID
          ,grade_id                                                   GRADE_ID
          ,budget_value                                               HEADCOUNT_VALUE
          ,budget_value * DECODE(orgmgr.sub_relative_level, 0, 1, 0)  DR_HEADCOUNT_VALUE
          ,SYSDATE
          ,l_user_id
          ,l_user_id
          ,l_user_id
          ,SYSDATE
     FROM  hri_mb_bdgts_ct bdgts
          ,hri_cs_suph_orgmgr_ct orgmgr
    WHERE bdgts.organization_id = orgmgr.sub_organization_id
      AND bdgts.budget_measurement_type = 'HEAD';

Line: 153

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

Line: 244

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

Line: 255

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