APPS.HR_EMPL_VERF_UTIL SQL Statements

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

Line: 124

        select to_char(WF_ADHOC_ROLE_S.NEXTVAL)
        into lv_role_name
        from SYS.DUAL;

Line: 206

    select name from fnd_currencies_tl
    where currency_code = p_code
    and language = userenv('lang');

Line: 211

    select meaning from hr_lookups hl
    where hl.lookup_type = 'PAY_BASIS'
    and lookup_code = p_lookup_code
    and hl.enabled_flag = 'Y'
    and sysdate between
    nvl(hl.start_date_active, sysdate)
    and nvl(hl.end_date_active, sysdate);

Line: 248

  FUNCTION UPDATE_TICKET_STRING(P_TICKET    in varchar2,
                                P_OPERATION in varchar2,
                                P_ARGUMENT  in varchar2)
  RETURN NUMBER IS
    return_value boolean default false;

Line: 254

    return_value := FND_HTTP_TICKET.UPDATE_TICKET_STRING(P_TICKET, P_OPERATION, P_ARGUMENT);