APPS.HR_AMM_SHD SQL Statements

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

Line: 38

    select
       authoria_mapping_id
      ,pl_id
      ,plip_id
      ,open_enrollment_flag
      ,target_page
      ,object_version_number
    from        hr_authoria_mappings
    where       authoria_mapping_id = p_authoria_mapping_id;

Line: 109

    select
       authoria_mapping_id
      ,pl_id
      ,plip_id
      ,open_enrollment_flag
      ,target_page
      ,object_version_number
    from        hr_authoria_mappings
    where       authoria_mapping_id = p_authoria_mapping_id
    for update nowait;