APPS.PER_SUC_SHD SQL Statements

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

Line: 87

         SELECT succession_plan_id,
                person_id,
                position_id,
                business_group_id,
                start_date,
                time_scale,
                end_date,
                available_for_promotion,
                manager_comments,
                object_version_number,
                attribute_category,
                attribute1,
                attribute2,
                attribute3,
                attribute4,
                attribute5,
                attribute6,
                attribute7,
                attribute8,
                attribute9,
                attribute10,
                attribute11,
                attribute12,
                attribute13,
                attribute14,
                attribute15,
                attribute16,
                attribute17,
                attribute18,
                attribute19,
                attribute20,
                job_id,
                successee_person_id,
                person_rank,
                PERFORMANCE,
                plan_status,
                readiness_percentage
           FROM per_succession_planning
          WHERE succession_plan_id = p_succession_plan_id;

Line: 202

         SELECT     succession_plan_id,
                    person_id,
                    position_id,
                    business_group_id,
                    start_date,
                    time_scale,
                    end_date,
                    available_for_promotion,
                    manager_comments,
                    object_version_number,
                    attribute_category,
                    attribute1,
                    attribute2,
                    attribute3,
                    attribute4,
                    attribute5,
                    attribute6,
                    attribute7,
                    attribute8,
                    attribute9,
                    attribute10,
                    attribute11,
                    attribute12,
                    attribute13,
                    attribute14,
                    attribute15,
                    attribute16,
                    attribute17,
                    attribute18,
                    attribute19,
                    attribute20,
                    job_id,
                    successee_person_id,
                    person_rank,
                    PERFORMANCE,
                    plan_status,
                    readiness_percentage
               FROM per_succession_planning
              WHERE succession_plan_id = p_succession_plan_id
         FOR UPDATE NOWAIT;