APPS.PQH_PQHWSOPS_XMLP_PKG SQL Statements

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

Line: 19

SELECT name
FROM hr_all_organization_units_tl
WHERE language = userenv('LANG')
  AND organization_id = p_organization_id;

Line: 25

SELECT meaning
FROM hr_lookups
WHERE lookup_type = 'PQH_POSITION_TYPE'
  AND  lookup_code = p_position_type;

Line: 31

SELECT name
FROM  FND_CURRENCIES_ACTIVE_V
WHERE currency_code <>'STAT'
AND currency_code = p_currency_code;

Line: 37

SELECT sysdate
FROM dual;

Line: 77

Select System_Type_cd
from Per_Shared_types
Where Shared_type_id = Budget_Unit_id1;

Line: 100

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

Line: 219

Select System_Type_cd
from Per_Shared_types
Where Shared_type_id = Budget_Unit_id;

Line: 260

        select system_type_cd
          from per_shared_types
          where shared_type_id = budget_unit_id and
                lookup_type = 'BUDGET_MEASUREMENT_TYPE';

Line: 282

        select system_type_cd
          from per_shared_types
          where shared_type_id = budget_unit_id1 and
                lookup_type = 'BUDGET_MEASUREMENT_TYPE';