APPS.PQH_PQUBGTEN_XMLP_PKG SQL Statements

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

Line: 10

select  '1'
  from pqh_process_log
 where module_cd = 'POSITION_BUDGET_ANALYSIS'
   and information12 = 'REPORT'
   and information11 like P_BATCH_NAME||'%';

Line: 17

Select trunc(sysdate)
  From dual;

Line: 20

   SELECT name
   FROM   per_organization_structures
   WHERE  organization_structure_id = p_org_structure_id;

Line: 25

    SELECT meaning
    FROM   hr_lookups
    WHERE  lookup_type IN ('PQH_BUDGET_ENTITY','UNDER_BDGT_EXTRA_TYPES')
    AND    lookup_code = p_entity_code;

Line: 117

    SELECT  bg.legislation_code
    FROM    per_business_groups_perf bg
    WHERE   bg.business_group_id = p_business_group_id;

Line: 139

  insert into fnd_sessions (session_id, effective_date)
 values(userenv('sessionid'),p_effective_date);