eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_BDGTS_LBRCST_ORGMGR SQL Statements

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

Line: 112


  INSERT INTO HRI_MDP_BDGTS_LBRCST_ORGMGR_CT (
     orgmgr_id
    ,effective_start_date
    ,effective_end_date
    ,organization_id
    ,job_id
    ,position_id
    ,grade_id
    ,element_type_id
    ,input_value_id
    ,cost_allocation_keyflex_id
    ,budget_value
    ,dr_budget_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(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
          ,element_type_id                                            ELEMENT_TYPE_ID
          ,null                                                       INPUT_VALUE_ID
          ,cost_allocation_keyflex_id                                 COST_ALLOCATION_KEYFLEX_ID
          ,budget_value                                               BUDGET_VALUE
          ,budget_value * DECODE(orgmgr.sub_relative_level, 0, 1, 0)  DR_BUDGET_VALUE
          ,budget_currency_code                                       CURRENCY_CODE
          ,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 = 'MONEY';

Line: 157


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

Line: 248


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

Line: 259


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