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 c.data_type
    into   l_data_type
    from   all_tab_columns           c
    where  c.owner          = l_username
    and    c.table_name     = 'PER_IMAGES'
    and    c.column_name    = 'IMAGE' ;

Line: 99

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