APPS.QA_LOCATION SQL Statements

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

Line: 50

        select location_code into loc_code
        from hr_locations_all
        where location_id = p_location_id;

Line: 70

        final(0) := 'SELECT 1 FROM qa_plan_chars qpc, qa_results qr
            WHERE qpc.char_id = :1 AND qpc.plan_id = qr.plan_id AND :2 = ';