DBA Data[Home] [Help]

APPS.HR_ADI_LOB_SHD SQL Statements

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

Line: 47

    select
       file_id
      ,file_name
      ,file_content_type
      ,upload_date
      ,program_name
      ,program_tag
      ,file_format
    from        fnd_lobs
    where       file_id = p_file_id;
Line: 111

    select
       file_id
      ,file_name
      ,file_content_type
      ,upload_date
      ,program_name
      ,program_tag
      ,file_format
    from        fnd_lobs
    where       file_id = p_file_id
    for update nowait;