APPS.PQH_RAP_SHD SQL Statements

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

Line: 49

    select
       rank_process_approval_id
      ,rank_process_id
      ,approval_date
      ,supervisor_id
      ,system_rank
      ,population_count
      ,proposed_rank
      ,object_version_number
    from        pqh_rank_process_approvals
    where       rank_process_approval_id = p_rank_process_approval_id;

Line: 122

    select
       rank_process_approval_id
      ,rank_process_id
      ,approval_date
      ,supervisor_id
      ,system_rank
      ,population_count
      ,proposed_rank
      ,object_version_number
    from        pqh_rank_process_approvals
    where       rank_process_approval_id = p_rank_process_approval_id
    for update nowait;