APPS.HR_TRV_SHD SQL Statements

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

Line: 73

    select
        transaction_value_id,
    transaction_step_id,
    datatype,
    name,
    varchar2_value,
    number_value,
    date_value,
    original_varchar2_value,
    original_number_value,
    original_date_value
    from    hr_api_transaction_values
    where   transaction_value_id = p_transaction_value_id;

Line: 147

    select  transaction_value_id,
    transaction_step_id,
    datatype,
    name,
    varchar2_value,
    number_value,
    date_value,
    original_varchar2_value,
    original_number_value,
    original_date_value
    from    hr_api_transaction_values
    where   transaction_value_id = p_transaction_value_id
    for update nowait;