APPS.PER_IMAGE_UPLOAD_PKG SQL Statements

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

Line: 20

    select u.oracle_username
    into   l_username
    from   fnd_oracle_userid         u,
           fnd_product_installations p
    where  p.application_id = 800
    and    u.oracle_id      = p.oracle_id;

Line: 27

   select col.data_type
    into   l_data_type
    from   user_synonyms syn, dba_tab_columns col
    where  syn.table_owner    = l_username
    and    syn.synonym_name   = 'PER_IMAGES'
    and    col.owner          = syn.table_owner
    and    col.table_name     = syn.table_name
    and    col.column_name    = 'IMAGE' ;

Line: 101

        'UPDATE PER_IMAGES
         SET IMAGE = (SELECT FILE_DATA
                      FROM   FND_LOBS
                      WHERE  FILE_ID = :1)
         WHERE IMAGE_ID = :2 '
    using file_id , image_id ;