APPS.CSP_PORTAL_EXCESS_PARTS_PVT SQL Statements

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

Line: 26

 select distinct organization_id,subinventory_code secondary_inventory_name,condition_type
   from csp_rs_subinventories_v
  where owner_resource_id = p_resource_id and
        owner_resource_type = p_resource_type and
        condition_type = p_condition_type and
       (EFFECTIVE_DATE_END is null or trunc(EFFECTIVE_DATE_END) > trunc(sysdate));

Line: 35

 select level_id from csp_planning_parameters
 where organization_id = p_organization_id and
       secondary_inventory = p_subinventory_code and
       condition_type = p_condition_type;