APPS.WSH_ITM_POST_PROCESS_HANDLER SQL Statements

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

Line: 48

                                SELECT COUNT(REQUEST_CONTROL_ID)
                                INTO   l_count
                                FROM   WSH_ITM_REQUEST_CONTROL
                                WHERE  REQUEST_SET_ID = p_request_set_id
                                AND    PROCESS_FLAG <= 0;

Line: 131

                        SELECT APPLICATION_SHORT_NAME
                        INTO   l_app_shname
                        FROM   FND_APPLICATION
                        WHERE  APPLICATION_ID = p_application_id;