APPS.HRI_OPL_SUPH_ORGMGR SQL Statements

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

Line: 112

  INSERT INTO HRI_CS_SUPH_ORGMGR_CT (
     sup_business_group_id
    ,sup_person_id
    ,sup_assignment_id
    ,sup_organization_id
    ,sup_level
    ,sub_business_group_id
    ,sub_person_id
    ,sub_assignment_id
    ,sub_organization_id
    ,sub_level
    ,sub_relative_level
    ,effective_start_date
    ,effective_end_date
    --
    -- WHO Columns
    --
    ,last_update_date
    ,last_update_login
    ,last_updated_by
    ,created_by
    ,creation_date)
   SELECT  SUP_BUSINESS_GROUP_ID
          ,SUP_PERSON_ID
          ,SUP_ASSIGNMENT_ID
          ,ORGANIZATION_ID SUP_ORGANIZATION_ID
          ,SUP_LEVEL
          ,SUB_BUSINESS_GROUP_ID
          ,SUB_PERSON_ID
          ,SUB_ASSIGNMENT_ID
          ,ORGANIZATION_ID SUB_ORGANIZATION_ID
          ,SUB_LEVEL
          ,SUB_RELATIVE_LEVEL
          ,EFFECTIVE_START_DATE
          ,EFFECTIVE_END_DATE
          ,SYSDATE
          ,l_user_id
          ,l_user_id
          ,l_user_id
          ,SYSDATE
     FROM hri_cs_suph ,
         (SELECT hoi.organization_id organization_id,
                 NVL(to_number(hoi.org_information2), -1) manager_person_id ,
                 NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,
                 NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time)   end_date
            FROM hr_organization_information hoi
           WHERE hoi.org_information_context = 'Organization Name Alias'
             AND hoi.org_information2 IS NOT NULL
             AND EXISTS ( SELECT NULL
                            FROM hr_org_info_types_by_class oitbc,
                                 hr_organization_information org_info
                           WHERE org_info.organization_id         = hoi.organization_id
                             AND org_info.org_information_context = 'CLASS'
                             AND org_info.org_information2        = 'Y'
                             AND oitbc.org_classification         = org_info.org_information1
                             AND oitbc.org_information_type       = 'Organization Name Alias')) org_manager
     WHERE sub_person_id = manager_person_id;

Line: 171

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

Line: 263

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

Line: 274

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