APPS.PQH_BPL_SHD SQL Statements

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

Line: 74

    select
       pool_id
      ,name
      ,budget_version_id
      ,budget_unit_id
      ,object_version_number
      ,entity_type
      ,parent_pool_id
      ,business_group_id
      ,approval_status
      ,wf_transaction_category_id
    from        pqh_budget_pools
    where       pool_id = p_pool_id;

Line: 149

    select
       pool_id
      ,name
      ,budget_version_id
      ,budget_unit_id
      ,object_version_number
      ,entity_type
      ,parent_pool_id
      ,business_group_id
      ,approval_status
      ,wf_transaction_category_id
    from        pqh_budget_pools
    where       pool_id = p_pool_id
    for update nowait;