APPS.PAY_TDU_SHD SQL Statements

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

Line: 50

    select
       time_definition_id
      ,usage_type
      ,object_version_number
    from   pay_time_def_usages
    where  time_definition_id = p_time_definition_id
    and    usage_type = p_usage_type;

Line: 123

    select
       time_definition_id
      ,usage_type
      ,object_version_number
    from   pay_time_def_usages
    where  time_definition_id = p_time_definition_id
    and    usage_type = p_usage_type
    for update nowait;