APPS.PQH_DEF_SHD SQL Statements

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

Line: 48

    select
       wrkplc_vldtn_id
      ,validation_name
      ,business_group_id
      ,employment_type
      ,remuneration_regulation
      ,object_version_number
    from        pqh_de_wrkplc_vldtns
    where       wrkplc_vldtn_id = p_wrkplc_vldtn_id;

Line: 119

    select
       wrkplc_vldtn_id
      ,validation_name
      ,business_group_id
      ,employment_type
      ,remuneration_regulation
      ,object_version_number
    from        pqh_de_wrkplc_vldtns
    where       wrkplc_vldtn_id = p_wrkplc_vldtn_id
    for update nowait;