APPS.AD_PATCH_LEVEL SQL Statements

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

Line: 21

  c_statement:= 'SELECT PI.PATCH_LEVEL FROM ' ||
                'FND_PRODUCT_INSTALLATIONS PI, FND_APPLICATION FA ' ||
                'WHERE FA.APPLICATION_ID = PI.APPLICATION_ID AND ' ||
                'UPPER(APPLICATION_SHORT_NAME)=' ||
                'UPPER(:short_name)';

Line: 66

  c_statement:= 'SELECT RELEASE_NAME FROM ' ||
                'FND_PRODUCT_GROUPS WHERE PRODUCT_GROUP_ID=1';