APPS.PAY_EST_SHD SQL Statements

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

Line: 47

    select
       element_set_id
      ,language
      ,source_lang
      ,element_set_name
    from  pay_element_sets_tl
    where element_set_id = p_element_set_id
    and   language = p_language;

Line: 113

    select
       element_set_id
      ,language
      ,source_lang
      ,element_set_name
    from        pay_element_sets_tl
    where       element_set_id = p_element_set_id
    and   language = p_language
    for update nowait;